String Operation Add Space to Postal Code

mattwelykholowa
mattwelykholowa Member
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!

Tagged:

Answers

  • GrantSmith
    GrantSmith Coach

    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!**

Categories