How to extract figures between two words?

[jp_jen]

Hi! 

I have reports that look something like this: 

Is it possible to anchor to extract out the figures? The reports contain a lot of words like "Venue Size" etc therefore I would like to anchor the back as well  (search for Venue Size and must end with sqm - for example). So far I was only able to use on one end i.e. search for Beginning words then extract out the remaining - but would be better if I can anchor the back. Any ideas on this? Appreciate any help, thanks! 

[atcodedog05]

Hi @jp_jen 

Its definitely possible Using Regex tool parse method. If you provide a sample file and expected output. we will able to help you much better 🙂

[jp_jen]

Thanks for your reply, unfortunately I cannot provide a sample file as it is contains restricted materials. It is like a financial report (with paragraphs, tables, images). 

I was able to use regex parse but only to search for the beginning (i.e. Venue size, pax allowed, administrative charges) but I had quite a lot of false results because these words were mentioned everywhere else. Was wondering if I could also anchor the back. 

Ultimately I want it to show something like this: 

Thanks!

[AkimasaKajitani]

I make sample.

But I think more better RegEx pattern.

You might try & error at RegEX.

Input

Output

[jp_jen]

Hi there, thanks! 

Just wondering, what happens if the figures appear on a separate line for e.g. 

Venue Size: 

392 sqm 

Should I input the RegEx into the multi-row formula? 

Some reports were split across rows. 

Thanks! 

[AkimasaKajitani · Accepted solution]

If you know what the split rows are, there is also a way to use RegEx tool by joining the rows together (using a multi-row formula tool or summarize tool).

sample

Input

Output