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.
Solved! Go to Solution.
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