Changing URL to text

user030230

I have a report from Salesforce that I moved into DOMO. In this report, there is a Website column, which acts as a hyperlink instead of text. However, I just want the text portion of the column, not the hyperlink. Whenever I export it as a .csv, the column changes to text but has a lot of other nonsense along with it. Is there a way in DOMO, whether through a dataflow or Beast Mode, that I can change the hyperlink column to plain text before exporting it?

MarkSnodgrass

Can you post an example of what is in that cell? Is it something like <a href=....>link name</a> ? You could write a beast mode to extract the portion in between the HMTL tags if that is what is in there, but I would need to see an example of what is there for sure.

Also, are you using the HTML table card right now? That is designed to automatically interpret HTML tags. Switching to a mega table would disable that, but the HTML would be showing to the user which would still need to be cleaned up.

MarkSnodgrass

Can you post an example of what is in that cell? Is it something like <a href=....>link name</a> ? You could write a beast mode to extract the portion in between the HMTL tags if that is what is in there, but I would need to see an example of what is there for sure.

Also, are you using the HTML table card right now? That is designed to automatically interpret HTML tags. Switching to a mega table would disable that, but the HTML would be showing to the user which would still need to be cleaned up.

jaeW_at_Onyx

ooof that's not as easy as it sounds...

 

IF you know you can always trim the first n characters you and the last n characters, you could use LEFT(), RIGHT(), and SUBSTRING or INSTRING() to just keep the middle, https://dojo.domo.com/t5/Dataflows/Fun-with-string-functions/td-p/32507

 

If the length of the tags you want to remove varies, you may have to write a more robust function.

https://forums.mysql.com/read.php?52,177343,177985

in a MySQL dataflow and then call the function.

user030230

Switching to an HTML table fixed it! Now when I export it, the URLs are unchanged. Thank you so much!