Working with non Ascii character
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Happy Alteryxing
Solved! Go to Solution.
- Labels:
- Expression
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Happy Alteryxing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, @binuacs
Dear, your regex expression is so cool , but could you please tell me that where are the [ -~] syntax from?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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], "[ -~]", '')
