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.
Depending upon your requirement please change the settings accordingly.
Can you post a screenshot of what you're seeing? The find and replace tool seems to be working correctly for me...
@lilyyangadsk you need to un-check match whole word.
Result:
Ashis
thank you it works now. Just want to ask for English character account name, should I also uncheck "match whole word only' too"
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.
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.
