Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Which junk characters / unicode is covered using this code?

Roche
8 - Asteroid

Hi everyone,

 

I have found a solution on the community that replaces junk characters with the actual English characters.  I would like to find out which characters are covered by this code.  Here is a screenshot of the RegEx code I used: 

 

Roche_0-1641276849011.png

Ultimately my aim is to cover all junk characters / Unicode and replace it with the English character.  Examples of junk / Unicode that the above code has covered in the data I work with are: ©, § which are replaced with a c and  which are replaced with nothing.  So I hope the above code is sufficient for the task.

 

Thank you 

 

2 REPLIES 2
atcodedog05
22 - Nova
22 - Nova

Hi @Roche 

 

Thank you this is helpful. Can you please attach the workflow too it will be much helpful. 🙂


Cheers and have a nice day!

Roche
8 - Asteroid

Glad you are helped.  I can unfortunately not attach the workflow as I use confidential data and my work belongs to a company.

Labels