Process Fixed Width Files

There isn't one step that is made to handle a fixed width file; however, we can set up a flow that can grab each row for us to process as needed.

You can pass the file into a Get String from UTF 8 Bytes step by setting the input to be the File Contents which while be a Byte list.  

Then using a Split String by New Line, you will get each line of the file in a String list.  

Next, pass your String list into a ForEach step so that we process each row.  Using the Split String by Character Positions step we can break the string down further to each individual field.



Any other processing you would like to do to each row can be done in this ForEach loop.  You will find more steps to help you manipulate the String data under the Data > Text section of the Toolbox.