How can one remove special characters in Alteryx- By special characters I mean - "నడకుడురు", "SAŔOJINI".
Like I want them to be only normal alphabets and numbers. It keeps showing the error- Output Data (17) PATNAME: "Mr. NIRANJAN’S KUMAR S" could not be fully converted from a WString to a String.
Hi @Simraneyy
Leveraging @binuacs 's reply, if you wanted to keep the 'R' you could do:
UPPERCASE(Trim(REGEX_Replace(DecomposeUnicodeForMatch([Field1]), '[^\sa-zA-Z]', '')))
This is one of my favorite RegEx questions. I once saw a shirt with the following on it:
[^ -~]
I immediately laughed (sick sense of humor).
It is an expression looking for non-printable ascii characters. Everything in the "normal" character set is between SPACE and TILDE.
REGEX_Replace([Field1], "[^ -~]", '')
This will eliminate all sorts of control or special characters. You can replace them with nothing (above) or with a space you decide.
Cheers,
Mark