How to remove accent from Names or any string field in Alteryx
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
s_das
7 - Meteor
‎01-02-2024
02:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
We got a dataset with lot of accents and special characters in multiple string fields (First Name, Last Name, Title). Want these special chars to be replaced. We are having issues with the decompose formula, and we don't want to modify existing casing to the dataset. what would be the best way to solve this issue at a time for multiple variables. Thank you.
Labels:
- Labels:
- Community
2 REPLIES 2
21 - Polaris
‎01-02-2024
05:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@s_das
Have you tried the Find and Replace tool?
If you have multiple fields we can also use the combination of Transpose and CrossTab to performe a dynamic Replace.
‎01-03-2024
07:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes, I used find replace tool but had to add more than one. Transpose would be good idea to take care of all variables at a time. Thank you.
