Forum Discussion
johnwedeles
Helper III
Helper IIIReplacing text with special character - check marks
Hello:
I have created a table visual. The underlying Excel table contains check marks, which were not retained when I imported the table. Now that I've imported the table, I'm trying to change the existing text in several columns (specifically, a "Y") to a check mark.
Based on preliminary research, I may be able to use the UNICHAR function to replace the "Y" with a check mark, but haven't gotten it to work. Would appreciate any guidance.
Thank you!
- Or:
Column = IF([Column1]="Y",UNICHAR(10003),[Column1]) johnwedeles - Yes, you could use a nested IF statement or use a SWITCH(TRUE()...) statement.
7 Replies
- Greg_Deckler
Community Champion
Or:
Column = IF([Column1]="Y",UNICHAR(10003),[Column1])
johnwedelesThat worked! Thank you very much! Greg_Deckler
- Greg_DecklerGlad to hear it!
- Greg_DecklerShould be:
Column = UNICHAR(10003)