Add multiple Hyperlinks in one cell

Hey there,

I have been trying to create a hyperlink in my cell using Domo Beastmode.

The issue is, if there is a string proceeding or following the link, the entire cell becomes a link.

Which is problematic because some cells are have multiple links with string while others have multiple links and no string.

Is there a way to hyperlink a value using DOMO Beastmode without turning my entire cell into a hyperlink?

I wish I could search the entire column for links and then turn it into a hyperlink, but I don't think that's possible in beastmode.

I've performed the following:

(CASE 

 WHEN `Significant Digital Projects` LIKE '%https://bit.ly/3vHrQoy%' THEN CONCAT(CONCAT('INSERT STRING EXAMPLE:'), CONCAT('<div><a href="https://bit.ly/3vHrQoy"','"target="_blank">','https://bit.ly/3vHrQoy','</a></div>'))

 ELSE `Significant Digital Projects` 

 END)

I've tried wrapping my string in a separate concatenate and then joining, but that didn't work.

Can anyone help? I want to do this in only beastmode. Not magic etl.

Answers