Creating a flat file with fixed width fields

jdl0523 · Jun 11, 2004

I would like to create a flat file with fixed field widths.
Using derived fields and Lpad, Rpad, Substr, and Concantenante functions I have been able to achieve this. However the problem i am having is that I need to wrap the field to the next line after the 96th character. Is this possible? If so, what approach should I take?

CharlesCook · Jun 12, 2004

You are going to need a macro to do this. In your macro you will loop through all the records writing them to a file and managing the 96 char issue.

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining

dlblack · Jun 23, 2004

Quick question, if you don't mind. Why do you need to wrap the record to the next line? This will require a carriage return and line feed and may make reading the file with another application difficult. I use several files with fixed field widths i.e record length 108, and I can read them ok.

David Black, CSQA
Sr. Systems Analyst
Teepak, LLC

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Creating a flat file with fixed width fields

jdl0523

Technical User

CharlesCook

Programmer

dlblack

MIS

Similar threads

Part and Inventory Search

Sponsor