Data Cleansing

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!

Workflow

Preparation

Accepted answers

All comments

regex_replace([field_name],"\n","")

I'm sorry that didn't seem to work, what did you use as the replacement text?

Am I understanding correctly that every cell that contains: _x000D_ .. you want to get rid of this part?

@sariyaj It would be very helpful if you can provide the input data in excel instead of the image.

Yes, and then display the rest of the data.

For example, this is what that first one looks like in Excel.

@sariyaj would you be able to attach the excel , when I tried to replicate the same I did not see the _x000D_ in my alteryx.

Sure, Here it is.

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

This is what it shows up as in my alteryx.

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

Remove_Char_011623.yxmd

No, there was no change

@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?

Remove_Char_011623.yxzp

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703