Data Cleaning

[SS_95]

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

[johnyli168]

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

[messi007]

@SS_95,

Could you share the data not a screen shot it will help us to give you the solution.

Regards

[SS_95]

Thank you so much, here is the dataset for your reference. Thanks 

[messi007]

@SS_95,

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,

[grazitti_sapna]

@SS_95, as @messi007  suggested to use a mapping table for achieving your goal. Here is another solution somewhat similar to messi007 but instead of two find and replace tool I used transpose and crosstab tool.

I hope this helps!

Thanks!

[SS_95]

Thank you so much!

[messi007]

@SS_95,

Happy to help :)

If our answers solve the problem please mark them as accepted solution.

It will help others.

Regards,