- Posts: 109
Text File Delimiter
- JD Cox
- Topic Author
- Offline
- User
Less
More
6 years 4 months 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 to join the conversation.
- FlowHeater-Team
- Offline
- Admin
6 years 4 months 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.
Please Log in to join the conversation.
- JD Cox
- Topic Author
- Offline
- User
Less
More
- Posts: 109
6 years 4 months 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 to join the conversation.
Time to create page: 0.278 seconds