Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.

We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Help : remove the non printable characters from text file

Thinesh_t
7 - Meteor

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.

3 REPLIES 3
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @Thinesh_t,

 

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

 

Jonathan

OllieClarke
13 - Pulsar
13 - Pulsar

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

 Thanks @OllieClarke, it worked

 
 
 
 
 
 
 
Labels