Number parse by specific text

[SagarGite]

Hi ,

I have data from which I would like to extract number which associated with key word "mg".

Between key word and number spaces can be associated or not.

Presentation	Expected OutPut
ARIPIPRAZOLE 30MG TABLETS	30
AROVI 100MG/1ML SOLUTION FOR INJECTION	100
ARTESUN 60MG POWDER AND	60
ARTESUNATE 50 MG TABLETS	50
ARSENIC 10 MG/10ML	10

Can someone hel

[ArtApa · Accepted solution]

Hi! This is a couple of examples how you can achieve the result: