Convert Text to WingDings the Count WingDings

Question

Hello Everyone,

I have a table with names in which I want to convert to wingdings, then count the wingdings vs the character count of the initial input.

Here is an example of what I want to do (or something similar);

Input:

Alteryx * Question

UBER  EATS

SMART *TT TESTING

Output:

If you look at the first one, there are more wingdings than characters in the name, right after uber there is an extra character. I want to be able to identify that and call it out,

Thanks!

mfranchino21 · Answer

Just to look for characters that are 'hidden' in the name. for example i need the exact character count in the uber example, but would've gotten it wrong bc of the hidden character.

Is there a way to could the dup whitespace removed? thx

fmvizcaino · Answer

Hi @mfranchino21 ,

You could use a data cleansing tool right before the conversion to eliminate all duplicated whitespaces.

Do you have a specific reason to convert to WingDings? I`m curious to know your use case since I was not familiar with WingDings until now 😁

Best,

Fernando Vizcaino