Convert Canadian Postal Code Ranges to Individual Values

I am working with a freight carrier who can only provide the Canadian postal codes where a surcharges is applicable in ranges. I need to break them out into individual codes to compare them to another carrier. The Canadian postal code is a six-character string that forms part of a postal address in Canada. The postal codes are alphanumeric. They are in the format A1A1A1, where A is a letter and 1 is a digit. Any help on this would be appreciated.

Canadian postal code ranges.yxmd

Parse

Preparation

Accepted answers

Philip

That's strange. I thought I had before. Here's my solution.

Canadian postal code ranges v02.yxmd

All comments

Philip

I'm not sure I understand. Could you take the first two rows and create the output you would like?

JordanB

@merickson

I have attached workflow which uses regex to split the alphanumeric parts. Similar to @Philip not quite sure what the outcome you want is but this should give you a a start.

Best,

Jordan Barker

Solutions Consultant

Canadian postal code ranges_V2.yxmd

merickson

I have attached a complete list of Canadian postal codes. The overall objective is to identify which codes fall into the range on each record. I have highlighted the postal codes that would fall into the first range (record#1). E6A1A0-E6A1Z9. Thanks for your help.

Canadian Postal Codes.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703