- Posts: 109
Text File Delimiter
- JD Cox
- Topic Author
- Offline
- User
Less
More
7 years 6 days ago #3390
by JD Cox
Text File Delimiter was created by JD Cox
I have a request from a new customer to export their data into a none delimited text file. This is an example of the first six columns N120FEDEX2DAY 9405515901870993406555 6 that's how they want it this is the best I can do N,120,FEDEX2DAY ,9405515901870993406555 , ,6 , ...Is there a way for me to export the data with the predetermined length and no delimiters?
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
7 years 5 days ago #3391
by FlowHeater-Team
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Replied by FlowHeater-Team on topic Text File Delimiter
Hello JD,
you just have to switch to “fixed width”, and set the desired field length on tab “Field / Data types” that’s all. You find an example in the attached ZIP archive.
you just have to switch to “fixed width”, and set the desired field length on tab “Field / Data types” that’s all. You find an example in the attached ZIP archive.
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Attachments:
Please Log in or Create an account to join the conversation.
- JD Cox
- Topic Author
- Offline
- User
Less
More
- Posts: 109
7 years 5 days ago #3392
by JD Cox
Replied by JD Cox on topic Text File Delimiter
As always Robert it did answer my question. I was so focused on the delimiter settings I totally missed the fixed width.
Thank you, it worked perfectly, JD
Thank you, it worked perfectly, JD
Please Log in or Create an account to join the conversation.
Time to create page: 0.263 seconds