I need to clean my data set, as the first and last name has some characters, I used DecomposeUnicodeForMatch but it didn't work out for all characters, I am asking the community to help me out. Thanks
Hey there @SS_95,
As you may have seen and tried the DecomposeUnicodeForMatch function (link here for anyone else - https://help.alteryx.com/20221/designer/string-functions)
Failing that, the other suggestion I would have is to utilise a find and replace table where you map out the letter you are working with and expected output.
See this other community article for more examples of other methods: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Remove-special-characters-from-a-list-...
Could you share the data not a screen shot it will help us to give you the solution.
Regards
I created a mapping table to replace the special charcter.
Then I used a find and replace for the first and last name.
Attached the workflow.
Regards,
Thank you so much!
Happy to help :)
If our answers solve the problem please mark them as accepted solution.
It will help others.
Regards,