06-15-2017 09:36 PM
Hi, I'm trying to find if there is a space after the last 3 digits then it's a canadian address otherwise it's US.
23 Yonge st. M4H 6F7
23 Yonge st. 902910
827 Bla Bla Rd. T7G 7K2
Sammy Rd. 38278
where there is a postal code I'd say Canadian and 2 and 4 are US.. So I figured if there is a space after the last 3 digits from the right then it's Can, otherwise US.
06-15-2017 09:47 PM - edited 06-15-2017 10:41 PM
You could use variations of:
if length(scan(ADDRESS,-1)) in (3,6) then COUNTRY='CANADA';
06-15-2017 09:50 PM
A different option
1. Use COUNTW to determine the number of words
2. Find last word
3. If Length = 5 then it's US, otherwise, it's CAN.
The Perl is more efficient though
length country $8.; n_words = countw(text); last_word = scan(text, n_words); if length(last_word)=3 then country = 'CAN'; else if length(last_word)=5 then country='US'; else country='CHECKME';
Need further help from the community? Please ask a new question.