How to Split a CSV Out When New Record Starts on New Row

Hello! I'm having trouble working with the following dataset. As you can see, the data are separated by commas and a new record starts on a new row. However, the last field from any record is not followed by a comma between that field and the first field on the next record.

Can anyone give me tips on how to neatly transform this into a table with columns and rows? Ideally after I figure out how to parse it out, I will not even go the route of reading from a CSV. The CSV was an intermediate step, but I was originally reading from a webpage and only put a .cvs step in there because I thought it might allow me additional flexibility in parsing the data.

Thanks! Kurt

2020-01-31.csv

Workflow

Datasets

Accepted answers

Greg_Murray

Hi @kurtwz,

You can use the text to columns tool to split to rows on new lines. See attached.

split new line ex.yxzp

All comments

Greg_Murray

Hi @kurtwz,

You can use the text to columns tool to split to rows on new lines. See attached.

split new line ex.yxzp

fmvizcaino

Hi @kurtwz ,

Take a look at the attached example and let me know if this works for you.

Best,

Fernando Vizcaino

2020-03-17 How to Split a CSV Out When New Record Starts on New Row.yxmd

grossal

Hi @kurtwz,

I wouldn't attempt to solve this in Alteryx, I'd quickly fix the input.

Remove the first row "DownloadData" and the first two characters in the second line as well as the last character at the end of the file and it's a perfect csv file that works with default settings in Alteryx.

Regards

Alex

kurtwz

Thanks very much for the support, Fernando!

kurtwz

Worked like a charm and you win the speediness race! That was too easy for you, though! 😛 Thank you for the help Greg!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703