Pipe delimited text help

[ewhulbert]

I have a file that is a pipe delimited text file. I used the file reader node and entered “|” into the node as the column delimiter. There are a couple of columns where for reasons I am not entirely sure of are combinations of multiple columns where the delimiting did not seem to take.

I have one column that is actually 6 columns together, what do you think is my best option for splitting them into several columns? Here is an example of one column that should be six separate columns (date / double / double / double / double / string).

07/05/2018"|2.00000|1.2100|2.42|0|"USD

In the columns where it is two columns joined I am going to simply use the string manipulation node, but for this one is there a better way? My regex skills are non-existent, wondering if it is worth working on learning regex to handle this one.

Appreciate any help you can give.

Thanks,
Eric

[ewhulbert]

Nevermind, I found the cell splitter node.

Wow, what a great option for this. That was super easy!

[mlauber71]

Another option could be to use r with readr package. That typically handles complex or strange CSV files well.

Import CSV data with R's readr – mlauber71

[ewhulbert]

Appreciate the suggestion, its probably a good idea.

I am trying to build stuff I can pass off to clients, none of whom can code, so I stay away from using R or Java.