Hi everyone,
I have found a solution on the community that replaces junk characters with the actual English characters. I would like to find out which characters are covered by this code. Here is a screenshot of the RegEx code I used:
Ultimately my aim is to cover all junk characters / Unicode and replace it with the English character. Examples of junk / Unicode that the above code has covered in the data I work with are: ©, § which are replaced with a c and which are replaced with nothing. So I hope the above code is sufficient for the task.
Thank you
Hi @Roche
Thank you this is helpful. Can you please attach the workflow too it will be much helpful. 🙂
Cheers and have a nice day!
Glad you are helped. I can unfortunately not attach the workflow as I use confidential data and my work belongs to a company.