Adding Space to Postal Code TEXT String in Magic ETL

mattwelykholowa

Hi,

I might be missing something but looking for some help to add a space to a postal code text string using Magic ETL. I am trying to change a postal code from S4L1A5 to S4L 1A5. thx!

MarkSnodgrass

If your postal codes are the same length and you want to add it after the 3rd character, you can do this:

CONCAT(LEFT(postalcode,3),' ',RIGHT(postalcode,3))

mattwelykholowa

@MarkSnodgrass awesome, thank you!

MarkSnodgrass

@mattwelykholowa glad that worked for you. If you can mark the answer as accepted, that will help others in the community.