| Date: | Thu, 22 Apr 2004 14:26:20 -0700 |
| Reply-To: | Art <artshen@HOTMAIL.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | Art <artshen@HOTMAIL.COM> |
| Organization: | http://groups.google.com |
| Subject: | match string patterns |
| Content-Type: | text/plain; charset=ISO-8859-1 |
I have a field which mixes addresses, cities and postal code etc. Is
there any function or method that I can use to find out the only the
postal code(a string pattern)?
eg.
Apt 16
123 any street
3456 any Ave.
M5E 7B7 <-----needs to be identified
L2T 9Y1 <-----needs to be identified
New York
Toronto
Thanks
Art
|