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.
Solved! Go to Solution.
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.
