What delimiters should i use for this file

[Data_Alter]

No delimiter is working on the above file , it has million rows

[atcodedog05]

Hi @Data_Alter 

You can use | (pipe) as delimiter to split and use data cleansing to clean the data. If you provide sample data I can help you with an example.

Hope this helps : )

[Data_Alter]

I get the below error when i use pipe

[atcodedog05]

Hi @Data_Alter 

Please provide a sample file.

Happy to help 🙂

[Luke_C]

Hi @Data_Alter 

That error would indicate there's some data in a record or records that has one too many fields based on the pipe delimiter. Try using \0 as the delimiter on the input tool then using a text to columns tool to split the data and review the records causing the problem.