Hi!
I'm intrigued by a charactere that is hidden in my data.
In cell view, it shows as this arrow charactere
I tried data cleansing but the arrow keep in my data,
Anyone knows what cause this ?
Solved! Go to Solution.
I can't say what caused it, but I might suggest changing the code set of that field to get rid of it. The ConvertToCodePage( will allow you to apply a code page to that field that supports the characters you want (or doesn't support the character you don't want in this case). Setting the code page of that field to something like UTF-8 should remove that unusual character. The code page reference for UTF-8 is 65001, so you would apply the function to [Field1] like this:
ConvertToCodePage([Field1],65001)
If you have multiple fields with unusual characters, the Multi Field Formula can apply this to all the fields you select in the tool with this:
ConvertToCodePage([_CurrentField_],65001)
I've attached a workflow with an example of each. Check it out and let me know what you think.
Hi @mdsalmankhan89, thank you thor the reply.
Unfortunately my company have very strict rules on sending files to internet, even when there is no important information conteaned in the file
@CharlieS That worked just Fine!