asked on

Regular Expression Question

Hi,

I'm using OCR to translate a bunch of bills to text format, what i want to do is then transfer some of the data from the text outputs into a database.

I'm struggling with the reg exp part of it for identifying a payment was made:

Payment Voucher - Cheque 0.00 19.97 0.00

is the text and i want to extract the middle value (in this case 19.97)

As it can be payment voucher - S/O or many other things i can really only work on the word 'Payment'

How can i create a regexp to identify a row with the word payment then return the second integer it comes across (i.e. 19.97) in this case?

Cheers

Brendan

ozo

Payment.*?\d\s+(\d+\.\d+)

Brendan

ASKER

Hi Ozo,

When i try that on regexr.com it brings back the full line, whereas i only want it to return '19.97'

kaufmed

Inspect capture group 1 from ozo's pattern. It container the 2nd value from the original string.

Brendan

ASKER

Hi käµfm³d,

Can you explain what you mean?

Cheers

Brendan

kaufmed

What tool are you using to execute this regular expression? Is it a text editor? A programming language?

Brendan

ASKER

Ive tested it on regexr.com (theres an editor you can use on that website to test regular expression) think its written in Java.

Cheers

Brendan

ASKER CERTIFIED SOLUTION

kaufmed

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Shailesh Shinde

Hi,

Try

Search : Payment.*?\d+\.\d+.*?(\d+\.\d+).*?\d+\.\d+
Replace: \1

Thanks,
Shail

Shailesh Shinde

Hi,

Sorry, please ignore my answer.

Thanks,
Shail