I try to extract the currency ISO (e.g. CAD in the example below) using RegEx.
I was thinking to use a positive lockbehind, but seems that I can’t use a wildcard inside of it.
How do you suggest to do it? It works in the case below if I try only
but it’s too generic.
Do you have a better idea?
here is text sample:
TO ACME Systems Inc.
Somewhere Road, 59
Payment Terms are seven days from receipt of invoice with authorised timesheet
Vendor: Megatronic Incorporated
Address: Strada Sperantei la parter
Invoice ID: 356147
Subtotal: 217496 CAD
Tax: 43499.2 CAD
Total: 260995 CAD