Creating a flat file with fixed width fields

[jdl0523]

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]

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]

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