Adding Space to Postal Code TEXT String in Magic ETL

mattwelykholowa · March 2022

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 · March 2022

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 · March 2022

@MarkSnodgrass awesome, thank you!

MarkSnodgrass · March 2022

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

Adding Space to Postal Code TEXT String in Magic ETL

Answers

Categories