I guess I need your help on how to convert CSV file that doesn't contain any delimiters to a usable format. Do you have any ideas on how to do text to the column without applying the RegEx tool? Will appreciate your ideas. Thank you!
Thanks for your prompt response, I tried to use '\0' and it didn't work for me, I'm not sure why. But I think there is the only way to resolve this issue is to apply the RegEx tool. It's very poor data quality.
We need to see the actual data to figure out if there is some way to separate the numbers. Can you provide a file with the data rather than an image? I'm guessing there are some spaces in there somewhere -- if not, and assuming two decimal places on the numbers, the third number in the row is very long. Also, why do you not want to use REGEX? It is generally the best way to parse complex strings.
As per the image I couldn't find any delimiters so it is not a .csv file it is a .txt file and so you need to find a logic to split it. Yes, you can use some regex statement. If the size of fields is fixed you can try Right or Left statement.
Thank you! It was a CSV file, I resolved that issue through applying the RegEx tool and through applying the text to the column tool and using '\t 'as a delimiter. I'm not sure why the tab delimiter has not been shown in the original data, but I was able to figure it out after.