community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Convert Canadian Postal Code Ranges to Individual Values

Meteoroid

 

 

Thanks. This is exactly what I need. The work flow is laid out very well and is easy to understand. I should be able to apply solution to other carriers and international postal codes. 

Highlighted
Meteoroid

This was helpfull, but was not 100% successfull. The solution will not capture all of the postal codes in the range using a 4 character match code. The forth character is also a variable. In the range E6B1A0-E6B2Z9 there is a E6B1 and E6B2. 

 

Thanks, 

 

 

Quasar

Were these past two in response to my solution, or to Jacob's? Just wanting to know if you need more help.

Meteoroid

@philip

 

Your solution was sucessfull. Thanks for your help.  

Labels