Hi @ajisafeadeoye , as this appears to be a fixed-width field file structure, I think a File Reader and a Cell Splitter By Position should be a starting point.
In the File Reader, untick the column header box
To determine the configuration, you will need to open the file in an editor that can show you the cursor’s column position and find where each field ends.
e.g. in Visual Studio Code it might look like this:
Once you have the end positions for each column, you can put the list in the
Cell Splitter By Position node
From the rows I inspected, and making guesses, I believe that the following end positions work for the sample file:
You will then have to give each column a name
There should be one more column name than there are split positions, since you are defining the points where data splits, rather than the start or end of every column.
Your data should then be in columns which you will then need to decide what to do with. Hopefully you have some details of what each column represents:
Edit: Looking further down the file, I realised I had missed another column, so I think you may need a cell split such as:
and then you’d need an additional column
Obviously you will need to check if the cell splits are correct and work for you!