Get numbers based on specific text

[SagarGite]

Hi,

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

Presentation	Expected OutPut
ARIPIPRAZOLE 30MG TABLETS (CRESCENT PHARMA LTD) 28 TABLET 2 X 14 TABLETS	28
AROVI 100MG/1ML SOLUTION FOR INJECTION PRE-FILLED SYRINGES (ROVI BIOTECH LTD) 10 PRE-FILLED DISPOSABLE INJECTION 5 X 2 PRE-FILLED SYRINGES	10
ARSENIC 10MG/10ML CONCENTRATE FOR SOLUTION FOR INFUSION VIALS (FLEXIPHARM AUSTRADING LTD) 10 VIAL	10
ARTESUNATE 50MG TABLETS (IMPORTED (CHINA)) 12 TABLET	12
ASACOL 250MG SUPPOSITORIES (ALLERGAN LTD) 20 SUPPOSITORY	20
ATOMOXETINE 100MG CAPSULES (NEURAXPHARM ARZNEIMITTAL GMBH) 28 CAPSULE 4 X 7 CAPSULES	28

Key words

TABLET

PRE-FILLED DISPOSABLE INJECTION

VIAL

TABLET

SUPPOSITORY

CAPSULE

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

[christine_assaad · Accepted solution]

Hello @SagarGite 

Please check this WF out. Hope it helps!

[Danish409 · Accepted solution]

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