Here’s my output using Monarch. And I’m trying to parse the text file thru KNIME. If there’s a node equivalent or same with monarch parser? or even just the proper alignment of white spaces.
I tried Fixed Width File Reader but in my case it will not work.
I have to deal with text files like that at work. There’s two things you can do:
Use the Fixed Width File Reader and set up the column widths manually
Use the “normal” File Reader and read everything into a single column
then remove all duplicate whitespaces
finally use a Cell Splitter on that column to split the lines up into different columns
I went with the second way, because I also have an arbitrary number of header lines I need to get rid of.
The functions in the String Manipulation nodes are removeDuplicates($yourColumn$) and possibly strip($yourColumn$).
@seanmanzanilla
Here’s my suggested workflow KNIME_project5.knwf (13.0 KB)
I’ve set the width of the first columns only, leaving the remaining 14, that contain no blanks, in a single column, then I’ve split them using a blank as the separator. You’ll need to rename them by hand.