Removing invalid character

[david20100]

In My ERP system (Second picture) i have a remarks field that is a big text box with space and carriage returns, when i bring that data in alteryx (first picture) i got a lot of unwanted characters (_X00D_  How to remove those unwanted characters?

thanks

[JoshKushner · Accepted solution]

You can remove the string with this formula: 

Replace([Remarques], "_x00D_", "")

Then you can use the Data Cleansing tool to clear the whitespace

[david20100]

Thanks, i almost told you that was not working, you forgot an 0, now its working thanks alot