CSV Input - Remove Line Break, split to column

[kliwag]

Having trouble inputting a CSV that has cells with line breaks.  Hoping to be able to take the multi lined cell and split into columns.  Any help would be appreciated.  Have tried some regex solutions to similar problems in the community but no luck.

[jastamme]

Not sure but does this work for you. Just replace the line break with a comma and then split the columns out using the comma

[KGT]

Yep, as @jastamme said!

Is AlteryxResult.png your input data? In that case, it's an issue with your config on the Input Tool. Make sure to "Ignore delimiters in quotes".

If the data is read in with things in the correct cells, then the easy way to blow out to lines is using the Text to Columns tool (possibly with "Split to rows" selected, then crosstab) and the delimiter set as "\n" with no quotes of course. 

[kliwag]

Yea the alteryxresults.png was my input data. but 'ignore delimiters in quotes' was already set. Have also been playing with the AMP only options as well.

[OllieClarke · Accepted solution]

@kliwag 
If you want a RegEx solution, and you know there will always be a fixed amount of columns (like the 3 in this case). Then you can use Tokenise 

You input tool will look like this:


And your workflow will look like this:

Tokenising on 

[^\n]+

Will put all consecutive non-newlines into a column, and then make a new column after each newline

Hope that helps,

Ollie

[kliwag]

@OllieClarke that did it!  Thanks Ollie and all.