I am trying to extract units of measure from strings in an Oracle database that houses a pharmaceutical catalog. I have been using regexp\_substr to get the concentration of a medication from a string

ie.

```
Name col in schema:
CYCLOSPORINE 100MG 30 CAPS
TERBUTALINE 2.5MG 100 TABS 

```

Output of query:

```
col 1: CYCLOSPORINE 100MG 30 CAPS, Col 2: 100MG
col 1: TERBUTALINE 2.5MG 100 TABS, Col 2: 2.5MG     

select name, 
regexp_substr(upper(name), 
'(\d*\.*\d+\s*ML|\d*\.*\d+\s*MG|\d*\.*\d+\s*OZ|\d*\.*\d+\s*LB)') 
CONCENTRATION 
from schema.table t 
where t.discontinuedflag=0
and t.restrictioncode <> 0
and t.distributor_id =19

```

Anyone know how I could pull out `200MG/mL` using regexp\_substr() in Oracle from the string below?

```
'TESTOSTERONE CYP 200MG/mL 10ML VIAL C3' 

```