Special characters

[Simraneyy]

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.

[binu_acs]

@Simraneyy 

Trim(REGEX_Replace([Name], '[^\sa-zA-Z]', ''))

[Alteryx_AR]

Hi @Simraneyy,

Try-

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

Hope this helps.

[Luke_C]

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]', '')))

[MarqueeCrew]

@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