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!
Solved! Go to Solution.
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 🙂
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!
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!