String Operation Add Space to Postal Code

mattwelykholowa · 2022-03-29T20:43:01+00:00

There was an error rendering this rich post.

Hi All,

I cannot seem to find out how to add a space to a Postal Code Column using new Magic ETL. Trying to change a text string eg: S4L1A5 to S4L 1A5. thx!

Find more posts tagged with

Magic ETL

Assuming it's always 6 digits:

CONCAT(LEFT(`Postal Code`, 3), ' ', RIGHT(`Postal Code`, 3))