Special characters

Question

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.

MarqueeCrew · Answer

@Simraneyy ,

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

Luke_C · Answer

Hi @Simraneyy

Leveraging @binu_acs 's reply, if you wanted to keep the 'R' you could do:

UPPERCASE(Trim(REGEX_Replace(DecomposeUnicodeForMatch([Field1]), '[^\sa-zA-Z]', '')))

Alteryx_AR · Answer

Hi @Simraneyy,

Try-

Regex_Replace ([Field1],"[^a-zA-Z]",'') .

Hope this helps.