Text to Columns Commas

[rmartinez4]

Hi All,

I tried using text to columns to separate a text data in a cell by a comma delimiter but its not catching all the comas to delimit. Is there away around it? Why is Alteryx missing the commas?

I have about 73K rows the varies from similar to this address this data 

IP

12545:4edT,000.16.99.000,000.001.000,12545:4edT,000.16.99.000

12545:4edT,000.16.99.000,03.001.000.12,03.001.000.12

12545:4edT,000.16.99.000,000.001.000.1,000.16.99.000

The result should be to split all the data into separate columns but it seems to leave some of the data how looks it below.

Here is probably a bad example : (. I also have an ID column and date attached to this data. I can't share all the since its sensitive but I don't kow why text to columns is missing the commas.

IP Address                                                                                                                   IP Address1

12545:4edT,000.16.99.000,12545:4edT,000.16.99.000                                          12545:4edT,000.16.99.000   

12545:4edT

12545:4edT

Thank you for the help in advanced.

[SPetrie]

If im understanding this right, it looks like your column split is setup for up to 3 columns. That means it will only catch 2 commas creating 2 columns and leave the rest of the data in the 3rd column. You need to increase the number of created columns to match the expected number of output columns.

[Robin_McIntosh · Accepted solution]

Duplicate post.  Already answered here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Text-to-Columns-issue/td-p/987893