FIND REPLACE, does it support find chinese character and replace with english 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
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.
Solved! Go to Solution.
- Labels:
- Data Investigation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can you post a screenshot of what you're seeing? The find and replace tool seems to be working correctly for me...
- 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
thank you it works now. Just want to ask for English character account name, should I also uncheck "match whole word only' too"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Depending upon your requirement please change the settings accordingly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.