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