How to extract figures between two words?

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!

Text Mining

Data Investigation

Accepted answers

AkimasaKajitani

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

SampleWF_2.yxmd

All comments

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.