This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Module Attached: Attached is a workflow which creates this layout, all it requires is an input with field names, type and Length columns. The workflow inserts the preset headers and footers to the file format (Underlined in the example format above). The module outputs a flat file (*.flat) which is an accepted format to read in non-defined file formats.
***There will be an error when you open the workflow due to 'no ouput being specified'. The output tool just needs to be configured to specify an output location to write too.
Reading your fix width file: In a new module you can then input your ascii flat file and when prompted to read in the file, 'read in as a fixed width text file'. In the next window, select the radio button ‘Use field settings from file’ and then select the flat file you produced from the attached workflow. This will then update the flat file layout window with the file format you inputted from the generated *.flat file. You can then click OK and the file will be read in with the fixed width dimensions.