User bio
404 bio not found
Member since Mar 21, 2016
Posts:
Replies:
If REC is consistently 3 "Words" with or without the comma then this should work...
s REC="MILFORD OH 12345"
s REC=$tr(REC," ",",")
s CTY=$p(REC,","),STA=$p(REC,",",2),ZIP=$p(REC,",",3)
sticking with your original plan of using $zstrip you could also do this:
s ZIP=$zstrip(REC,"*E'N") ; Strips Everything (*E), Except Numeric ('N) but this is a bit dodgy as if there's any other number in the string it will appear in the result
Certifications & Credly badges:
Keith has no Certifications & Credly badges yet.
Global Masters badges:
![Open Sesame!](https://community.intersystems.com/sites/default/files/badges/303371180-6de11138-f4e7-4113-b5cc-836269f07693.png)
![1,000 Points](https://community.intersystems.com/sites/default/files/badges/290121674-53216c4b-fe0c-44e7-9d75-2f24390135ed.png)
![Challenge Starter](https://community.intersystems.com/sites/default/files/badges/295959213-b83dd91a-663f-4f07-8e0e-e3287b7c2309.png)
![DC Commenter](https://community.intersystems.com/sites/default/files/badges/dc_commenter_1.png)
![DC Problem Solver](https://community.intersystems.com/sites/default/files/badges/dc_problem_solver_1.png)
![InterSystems Researcher](https://community.intersystems.com/sites/default/files/badges/researcher.png)
Followers:
Keith has no followers yet.
Following:
Keith has not followed anybody yet.
You're probably aware but just in case you arent there's a couple of routines that might be worth taking a look at in the %SYS namespace - ^LOCKTAB and ^%IS