Skip to main content

Table 1 Regular expressions used to remove non-systemic medications

From: Use of electronic pharmacy transaction data and website development to assess antibiotic use in nursing homes

Regular expressions Description and example Strings
[^[:alpha:]]STRING Drug Name that ends with [Non Alphabetic Character]STRING
e.g., HYDROCORTISONE 2.5% CREAM
CREAM, CRM, DROP, EAR, EYE, EYEOINT, FOAM, GEL, INHALER, INHAL, LOTION, MOUTHWAS, MOUTHWASH, NASAL, OINT, OINTM, OINTMENT, OPTH, OPHTH, OTIC, PATCH, RINSE, SPRAY, TOPIC, TOPICAL, SHAMP, SHAMPOO, RINGERS, 1:1
[^[:alpha:]]STRING[^[:alpha:]] Drug Name contains [Non Alphabetic Character]STRING[Non Alphabetic Character]
e.g., PERMETHRIN CREAM 5% 60GM
CREAM, CRM, DROP, EAR, EYE, EYEOINT, FOAM, GEL, INHALER, INHAL, LOTION, MOUTHWAS, MOUTHWASH, NASAL, OINT, OINTM, OINTMENT, OPTH, OPHTH, OTIC, PATCH, RINSE, SPRAY, TOPIC, TOPICAL, SHAMP, SHAMPOO, RINGERS, 1:1
^STRING[^[:alpha:]] Drug Name that starts with STRING[Non Alphabetic Character]
e.g., GELFOAM SIZE 50 SPONGE
GELFOAM, WATER INJ, SSD, ABH
^STRING[^[:blank:]]%* Drug Name that starts with STRING[blank] and zero or more times of %
e.g., LIDOCAINE HCL 2% JEL
DS, LIDOCAINE, NACL, SODIUM CHL