FIND REPLACE, does it support find chinese character and replace with english character

[lilyyangadsk]

I tried to use find replace function to find Chinese character and replace, but however I tested many times and alteryx not recognize Chinese character, is it true, or I am wrong.

[echuong1]

Can you post a screenshot of what you're seeing? The find and replace tool seems to be working correctly for me...

[ashissanpui]

@lilyyangadsk  you need to un-check match whole word.

Result: 

Ashis

[lilyyangadsk]

thank you it works now. Just want to ask for English character account name, should I also uncheck "match whole word only' too"

[ashissanpui · Accepted solution]

Depending upon your requirement please change the settings accordingly.

[lilyyangadsk]

I am not quite understand about "match whole word only' mean exactly, my purpose is to clean legal entity suffix like LTD, Co Ltd, etc, and to find in account name and take away those words.

'match whole word only' means to match account name part of the field if any suffix exist, or it means the whole account name is this word Co Ltd.

[ashissanpui]

When you select match whole word along with entire field it does 'vlookup' in excel. Else the phrase you are searching will be matched within the string whereever the occurrences are. Try the help example embedded in Find and replace tool. You will get to understand that.

Company name: Limit ABC Company Limited 

Replace Limit with LT

then with the selection your result would be

LT ABC Company LTed.

Otherwsie, withi your initial match criteria it would give null.

Ashis

[Saumil]

Hi @echuong1,

In this example, instead of Replace I just want to Find the Keywords in the Chinese Sentences and in the Output I would like to display to 2 things: 1) Sentences where any Keyword is Found 2) Specific Keywords found in each sentence (in another column). Is this possible ?

Thanks.