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.
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board