String Operation Add Space to Postal Code

edited January 2023 in Magic ETL

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!



  • Assuming it's always 6 digits:

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

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**