Get numbers based on specific text

Question

Hi,

I have list of key words(hundreds of) based I would like to extract numbers pre associated with them.

PresentationExpected OutPutARIPIPRAZOLE 30MG TABLETS (CRESCENT PHARMA LTD) 28 TABLET 2 X 14 TABLETS28AROVI 100MG/1ML SOLUTION FOR INJECTION PRE-FILLED SYRINGES (ROVI BIOTECH LTD) 10 PRE-FILLED DISPOSABLE INJECTION 5 X 2 PRE-FILLED SYRINGES10ARSENIC 10MG/10ML CONCENTRATE FOR SOLUTION FOR INFUSION VIALS (FLEXIPHARM AUSTRADING LTD) 10 VIAL10ARTESUNATE 50MG TABLETS (IMPORTED (CHINA)) 12 TABLET12ASACOL 250MG SUPPOSITORIES (ALLERGAN LTD) 20 SUPPOSITORY20ATOMOXETINE 100MG CAPSULES (NEURAXPHARM ARZNEIMITTAL GMBH) 28 CAPSULE 4 X 7 CAPSULES28

Key wordsTABLETPRE-FILLED DISPOSABLE INJECTION VIALTABLETSUPPOSITORYCAPSULE

Can someone help me to get numbers by using regex with big key word list

Christine_Assaad · Accepted Answer

Hello @SagarGite

Please check this WF out. Hope it helps!

Danish409 · Accepted Answer

I totally agree with @christine_assaad.

Alternatively, we can also use text to column and formula tool to get the desired output. But of course Regex has its own advantages.

Please check out the alternative way to solve.

Spoiler