Help : remove the non printable characters from text file

[Thinesh_t]

Dear Friends,

i used to work with the clients ERP data which i used to receive in text file format and at time the file will be in broken because of Non printable characters(non keyboard characters) , New line , Carriage return, white space.

I am finding difficult to handle that data cleanse work , i need your suggestion/ if any workflow to help me handle this.

Thanks for your support.

[Jonathan-Sherman]

Hi @Thinesh_t,

Do you have any sample data and the outcome you're looking to achieve?

Jonathan

[OllieClarke · Accepted solution]

@Thinesh_t 

REGEX_REPLACE([Field],'[\x0-\x1f]','')

This should replace any non-printable ascii characters with nothing (I've taken the non-printable ascii from here https://flaviocopes.com/non-printable-ascii-characters/ ). Use it in a formula tool and let me know if that helps

Ollie

[Thinesh_t]

 Thanks @OllieClarke, it worked