Parsing a string containing Japanese characters

[jakemancer]

Hi all,

I have a number of records which contain both English (standard A-Z, 0-9) as well as Japanese characters. Is there any way to parse these strings, removing the Japanese characters and keeping just the English alphanumeric characters?

Many thanks

[BenMoss]

Can you please provide an example string with your desired result.

Ben

[LordNeilLord · Accepted solution]

Hey @jakemancer

You can use RegEx replace to remove any characters that aren't Alpha Numeric...you can also get it to maintain whitespace, full stops, commas etc...

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[jakemancer]

Legend

Cheers @LordNeilLord!