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?