Working with very wide fixed width files

I'm trying to set up the reader for a fixed-width file with 900 columns. I have a layout file with the column names and field widths: The widths are the 3rd row of the reader file. If there was a way to paste or load the definition into the data definition view that would be great. Is there any easy way to do this? I'm not going to type in 900 field widths. My best current idea is to create a table via SQL script, set the writer to look at that and use and copy the definition to the reader.

Click on data reader. Right-click in the middle of the data grid and select “Set number of fields”

Enter the number of fields

Click on data definition, click select all and then copy

Paste data into Excel and edit field names and widths Copy data from excel back into Advanced ETL Processor (Select fist cell fist, then select all and paste data)

Working with Fields Selector Object

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETl forum

  • knowledgebase/wide_fixed_width_files.txt
  • Last modified: 01/08/2022 14:03
  • by admin