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