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!
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
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