Me again. I am trying to figure out Regex these days and I am very appreciated for your help.
I have a small question with regex. I have an invoice text as below:
2481 Felosa Drive
Pin Code 78643
Sonja D. Eaton
4384 Heliport Loop
Orlando, Florida INVOICE
Pin Code 47635,
United State of America
Invoice # 102
Invoice Date: Apr 25, 2021
Due Date: May 11, 2021
ID DESCRIPTION QTY PRICE TOTAL
HI1-8-XC8 8GB RAM 1. 8400. 8400.
GX199 Keyboard 1. 9300. 9300.
AX-1000 Digi Mouse Wireless 1. 2300. 2300.
LXG2111 HDA Monitor Wireless 1. 4000. 4000.
Sub Total 24000.00
GST 8% 1920.00
I want to match “25920.00” which is Total in the last line. But when type regex code, it matches sub total and total both. How do i ignore sub total or how do i match only “Total”?
I also used (?<=^\bTotal: \b)\d+ but it didnt work.
Thank you for your help and time.