Data Cleansing

[sariyaj]

I keep seeing "_x000D_" on my data in Alteryx. In my excel sheet, it shows that there is a line break and then the rest of the data. I know to get rid of line breaks, I have to use the data cleansing tool and remove tabs and line breaks, but that isn't doing anything in this case. How do I get rid of "_x000d_" and display the actual data in that cell?

Thank you for the help!

[binuacs]

@sariyaj I am seeing the data like below in Alteryx. Can you screen shot your data in Alteryx

[sariyaj]

This is what it shows up as in my alteryx.

[binuacs]

@sariyaj Can you try the below Regex_Replace formula and see your issue fixed?

[sariyaj]

No, there was no change

[binuacs]

@sariyaj I am attaching my workflow with your input file. Can you try to run the attached workflow and see you are seeing the issue or not?