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.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 306 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 112 SQL DataFlows
- 649 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 788 Beast Mode
- 78 App Studio
- 43 Variables
- 745 Automate
- 187 Apps
- 475 APIs & Domo Developer
- 67 Workflows
- 16 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 406 Distribute
- 117 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 139 Manage
- 136 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 113 Community Announcements
- 4.8K Archive