General Discussions

Discuss any topics that are not product-specific here.

How to remove accent from Names or any string field in Alteryx

s_das
7 - Meteor

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. 

 

2 REPLIES 2
Qiu
20 - Arcturus
20 - Arcturus

@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.

0103_s_das.png

s_das
7 - Meteor

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. 

Labels