How do I replace text with unicode

suwandy · September 2019

Hello,

I'm trying to replace some characters in my table using Unicode Characters such as :white_heavy_check_mark: and with :cross_mark:

This is the code I typed into the Beast Mode but it's not displaying it and instead only showed the literal '✅', could anyone please help?

Case when `Last Week Actual` - `Last Week Target` >= -9999 then 
'&#9989;'
when `Last Week Actual` - `Last Week Target` >= 0.001 then 
'&#10060;'
else '' End

Thanks in advance.

Ashleigh · September 2019

Hiu @suwandy you have to include the <div> tag like this, I also attached a photo of what it showed.

CONCAT('<div style="">', -- Combine data and format

'✅',

' Hello ', COUNT(`IMPL_DT`),

'</div>' -- end format

)

Ashleigh · September 2019

Here is a knowledge base article with some other examples.

https://knowledge.domo.com/Visualize/Adding_Cards_to_Domo/KPI_Cards/Transforming_Data_Using_Beast_Mode/Adding_Graphics%2C_Links%2C_and_Images_to_Table_Cards_Using_Beast_Mode

suwandy · September 2019

Hello there,

Thanks for your response. I tried it however it only gave me this result instead (see attachment)

This is the new code I used.

Case when `Last Week Actual` - `Last Week Target` >= -9999 then 
CONCAT('<div style="">', '&#9989;', ' Hello ', '</div>' )
when `Last Week Actual` - `Last Week Target`  >= 0.001 then 
CONCAT('<div style="">', '&#9989;', ' Hello ', '</div>' )
else '' End

By the way, I couldn't see the photo you attached. Could you attach it again please?

Ashleigh · September 2019

@suwandy To see the image you have to download, for some reason they do not show just by clicking on it (could be computer security settings). I did not realize you were trying to get it in a table; the code I provided was for a summary number. I think to put it in a table you will want to use an image rather than the Unicode. In the link I provided in my last message, there is a section for how to add images to a table. I went ahead and did an example. Here is my code:

Case
when `Entered Hours` > 0 then CONCAT('<div style="text-align:center"><img alt="UP" height="20px" src="https://s3.amazonaws.com/pix.iemoji.com/images/emoji/apple/ios-12/256/white-heavy-check-mark.png">','</div>')

when `Entered Hours` <=0 then CONCAT('<div style="text-align:center"><img alt="UP" height="20px" src="https://banner2.kisspng.com/20180715/klo/kisspng-check-mark-emojipedia-computer-icons-symbol-cek-5b4bdef7a0b662.6919404015316989356583.jpg">','</div>')

else ''

End

Download the image to see what it made.

Ashleigh · September 2019

To get the links I just searched up the emoji and then right clicked on an image and selected copy image address

Magic ETL

Magic ETL

How do I replace text with unicode

Welcome!

Comments

Welcome!

Welcome!

Quick Links

Categories