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

LordNeilLord

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