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