FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the existing examples of using the TextFile Adapter , which may answer your question: text file codepage converting 1 / 2 , processing of CSV header and footer rows , Import/Export vCard (line based) text files
  • Page:
  • 1

TOPIC: Text File Delimiter

Text File Delimiter 2 years 1 week ago #3390

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.

Text File Delimiter 2 years 6 days ago #3391

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 or Create an account to join the conversation.

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.

Text File Delimiter 2 years 6 days ago #3392

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 or Create an account to join the conversation.

  • Page:
  • 1

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en