Magic ETL Replace String Blank Spaces
Is there a way to strip the blank spaces out of a text value in magic etl? My client is concatenating to text columns into a single column, and when they do it introduces a blank space between them. So the ask is to find a way of replacing/stripping that blank space with nothing. Tried text replace but no joy so far.
Thanks,
Mark
0
Best Answer
-
Yeah so... my mistake was to quote the blank spaces. If you just toggle the space bar one space to the right in the "to replace" box, and leave the "with" box unfilled, it has the effect of stripping out the blanks. Problem solved.
1
This discussion has been closed.
Categories
- 7.7K All Categories
- 12 Connect
- 925 Connectors
- 247 Workbench
- 441 Transform
- 1.7K Magic ETL
- 61 SQL DataFlows
- 456 Datasets
- 88 Visualize
- 222 Beast Mode
- 2.1K Charting
- 8 Variables
- 5 Automate
- 349 APIs & Domo Developer
- 85 Apps
- Workflows
- 17 Predict
- 3 Jupyter Workspaces
- 14 R & Python Tiles
- 242 Distribute
- 60 Domo Everywhere
- 241 Scheduled Reports
- 18 Manage
- 39 Governance & Security
- 46 Product Ideas
- 1.1K Ideas Exchange
- 6 Community Forums
- 19 Getting Started
- 6 Community Member Introductions
- 50 Community News
- 18 Event Recordings
- 577 日本支部