Convert Canadian Postal Code Ranges to Individual Values
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Parse
- Preparation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm not sure I understand. Could you take the first two rows and create the output you would like?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a solution, but can't seem to post the Alteryx Zipped solution (getting "The contents of the attachment doesn't match its file type.") I'll try sending by PM.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @merickson
Heres my workflow suggestion. I just took a unique code from each (first four alphanumeric values) to join back up and get your ranges next to the zipcode values.
Best,
Jordan Barker
Solutions Consultant
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Philip unfortunately you cannot post yxzp files to the community.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@JordanB I did upload a yxzp file here:
Is there different posting rules for the Advanced Analytics area?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Each knowledgebase has its own rules regarding publishing file types.
Best,
Jordan Barker
Solutions Consultant
![](/skins/images/A7612391DEAF4EF69C140133EA533832/responsive_peak/images/icon_anonymous_message.png)