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.
