Inserting line break according to a character
Is there a way to break a piece of text into a new line in a table by when a character appears? Everything I'm looking at goes by length of the string of text, but in my case it goes by a semicolon separator.
So I'll have in one cell a bunch of text of varying lengths and commas to separate that one instance BUT have a semicolon to separate it as another instance. What I would want to do is everytime Domo sees a semicolon it would start that as a new line break.
Is this possible through a Beast Mode? Would I have to do it in SQL or the ETL? I don't want to separate out the text into new columns or new rows or anything like that, just when I'm presenting it in the table view in my card for each entry separated by a semicolon to be on a new line.
Thanks!
Best Answer
-
You could try the Replace function in a beastmode. If you're replacing the semicolon with a line break it would look something like this:
REPLACE(`String`,';','<br>')
Give that a shot and let me know if you need anything else.
Sincerely,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.2
Answers
-
You could try the Replace function in a beastmode. If you're replacing the semicolon with a line break it would look something like this:
REPLACE(`String`,';','<br>')
Give that a shot and let me know if you need anything else.
Sincerely,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.2 -
works beautifully, thanks!
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive