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
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 543 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 6 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive