How to convert broken letters?

[knozawa]

Hello,

I am using Grid database and I found multiple broken letters.

The data field included " ◻ {\displaystyle \sqâ" that supposed to be "-", therefore, I used a formula to replace it.  Although the letter "â" was replaced to "-", the two squares were not removed in the data.  It seems like the actual data does not include two squares though...

Does anyone know how to handle this issue?

Sincerely,

Kazumi

[seven]

@knozawa 

You may not always have control over how the code page when inputting data. In any case, you can always use a function to change the code page. Use the MultiField Formula tool with this formula

ConvertFromCodePage([_CurrentField_], 65001)

[maleryx]

Can this be done from a data input non csv? like SQL DB? I tried the method TS used but failed as well

[warrencowan]

Great shout @Aguisande , saved me alot of time stumbling on this.

I had been finding and replacing these from my own custom list as I discovered them, and tbh was beginning to lose the battle and my will.

Alteryx is truly an iceberg and evey day's a school day.

Many thanks for being such a sterling contributor.

[Aguisande]

Hi @warrencowan 

Thanks for your words.

I'm so glad to be of help!

Keep unveiling the iceberg, you'll find awesome things beneath...