Cutting digits before a word

[EgorKraemer]

Hi all,

I´ve got following problem. I want to cut out digits in a string. The digits are before a specific combination of letters.

Example:

"IBUPROFEN 800MG BAY4G" --> 800

I want to search in the string for the combination "mg" and cut out the digits before it untill the next space.

Is it possible without Regex?

Any ideas?

[RolandSchubert · Accepted solution]

Hi,

I tried it with FindString to identify the first character after the digits, then ReverseString and FindString again to find the space, 
Substring and Reverse to get the number. I think, it should be checked, if the string contains "MG", but maybe the attached
workflow is a possible approach.

Best regards

Roland

[EgorKraemer]

Thank you Roland, for the fast help! You are my hero!