Working with non Ascii character

So I have some data that I would like to parse but hitting some issues. So for example I have this string

<div class=""tags""> 萓区枚・廱LPT N5 Tango </div>

If I use a replace formula on it like this below, you can see it doesn't change anything

But if I only use ascii characters it works as expected

Is there some setting I have to change in Alteryx to allow me to use the Kanji etc in expression? I have switched the language of designer to Japanese and that got me nowhere.

Workflow

Expression

Accepted answers

binu_acs

@Carlithian removing the ^ sing from the Regex_Formula will give you the non-ascii characters

All comments

binu_acs

@Carlithian Do you want to remove the non-ASCII letters?

non-ascii_1025.yxmd

Carlithian

I'm actually wanting to keep them, but continuing to play in designer I realised I made a silly mistake and it worked fine -.-
Thats a really useful formula, is there a reverse for getting rid of all ascii characters?

binu_acs

@Carlithian removing the ^ sing from the Regex_Formula will give you the non-ascii characters

flying008

Hi, @binu_acs

Dear, your regex expression is so cool , but could you please tell me that where are the [ -~] syntax from?

binu_acs

@flying008 [ -~]

[ -~] uses (space) followed by a dash followed by a tilde. This regex expression includes all the characters between space and tilde. If you see the below chart any character from 32 to 126 is replaced with '' as per the below regex formula and the rest of the characters will remain

REGEX_Replace([Field1], "[ -~]", '')

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703