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

  • Unknown
    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.

Answers

  • Unknown
    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.

This discussion has been closed.