How to convert CSV file without any delimiters to a usable format

[annamozul]

Hello all, 

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!

[meeravijayan2011]

Hi @annamozul 

If the .csv file doesn't have any delimiters provide the  '\0' in the input file delimiter section. I hope this will solve the problem. 

[annamozul]

Hi @meeravijayan2011 

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.

[TonyA]

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.

[meeravijayan2011]

Hi @annamozul 

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. 

[annamozul]

hi @TonyA 

Thanks for your response, I did it through applying the RegEx tool. I wanted to make sure if there are any other "easy ways" to resolve this issue.

Thank you! 

[annamozul]

Hi @meeravijayan2011 

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. 

Thank you for your help!