Preserving Rich Text Formatting from Jira
My team is leveraging a Domo Workbench connection into a on-premise Jira instance. Jira allows rich text formatting in many of the fields that we need, and I'd like to preserve that when I display the data in Domo text cards. I can see the patterns in formatting when I compare my Jira input to my Domo card (ex: [text] = _ + [text] + _, where text = * + [text] + *), but I can't figure how to to find the pattern and then apply specific formatting to the text in between. See attached for a comparison.
Can I do this via RegEx commands in Magic ETL - or is there an easier way in SQL? If RegEx, would I need to do a series of RegEx commands (1 for italics, 1 for bold) applied to every field where I'd want to have the card presented with the formatting?
I appreciate any help the user community could provide to me.