Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Text File Delimiter

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.

More
6 years 4 months ago #3391 by FlowHeater-Team
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.




File Attachment:

File Name: csv-to-fix...ngth.zip
File Size:2 KB

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 to join the conversation.

More
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

Please Log in to join the conversation.

Time to create page: 0.278 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.