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
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
Answers
-
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
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive