Convert Text to WingDings the Count WingDings

[mfranchino21]

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!

[fmvizcaino]

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

[mfranchino21]

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