Parse out a CSV

[Farriyajawed]

Hello, 

I am trying to parse out a csv in Alteryx with "," as my delimiter in text to columns tool. However, for some rows, it is stop parsing after a while. 

for example this is the input: 

22000,04/18/2023,04/18/2023,49239370-00,Bill - LOCKE SUPPLY CO.: 3/4" PEX BALL VALVE BRASS,Plumbing,,"Water Air, Plumbing and Electric",19351,APJ,10.78,,-3301.52

I have the output in the screenshot attached. it stops parsing after Plumbing and electric. 

Hoping to find a solution for this. 

[Raj]

@Farriyajawed 
while using Text to Column,

check the advance option, ignore delimiters in Quotes.

this will solve the problem.please maek it as done if this solves the problem.

[apathetichell]

ignore delimeters in quotes.

[Farriyajawed]

I am using the ignore delimiters in quotes option but still getting the same problem.

[aatalai]

@Farriyajawed increase the number of columns, does that help resolve the issue?

[Raj]

@Farriyajawed this works perfectly fine.

[Farriyajawed]

Raj, you workflow leaves everything in column 6 whereas everything needs to be parsed and" -3301.52" should be in last column

[Raj]

@Farriyajawed i reffered to the screen shot you added.
kindly add the required output, will help

[Farriyajawed]

Here you go!

[apathetichell]

You have an unmatched quote. Your data is wrong. You cannot do what you are doing with an unmatched quote.

change:

22000,04/18/2023,04/18/2023,49239370-00,Bill - LOCKE SUPPLY CO.: 3/4" PEX BALL VALVE BRASS,Plumbing,,"Water Air, Plumbing and Electric",19351,APJ,10.78,,-3301.52

to

22000,04/18/2023,04/18/2023,49239370-00,"Bill - LOCKE SUPPLY CO.: 3/4" PEX BALL VALVE BRASS,Plumbing,,"Water Air, Plumbing and Electric",19351,APJ,10.78,,-3301.52