Meta data manipulation, Text file breaking rows into columns

[ScottF]

Hi @michaellis -

It looks like the first thing to do here is to deal with multiple whitespace on your rows. @MH posted a good approach for this earlier today:

Removing multiple spaces from a string

Even though the problem has been solved. I would recommend to use a regular expression for these types of replacements. This way you can remove an arbitary amount of whitespaces. Use this in a String Manipulation Node and it should solve the problem nicely: strip(regexReplace($column1$,"\\s{2,}" ," ")) The \\s stands for whitespaces and the {2,} means two or more.

Once you are down to a single space delimiter, you can use the Cell Splitter node more easily. This probably won’t get you 100% of the way there, but hopefully it helps.