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.
- 7.4K All Categories
- 13 Getting Started in the Community
- 151 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 905 Connectors
- 239 Workbench
- 343 APIs
- 77 Apps
- 19 Governance & Productivity
- 237 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部