PDF content in to in to excel table

@srilakshmi_Tippireddy - I will try my best to provide the patterns by looking at the pic…

TO: (?<=TO\s?:).*(?=\sINVOICE)

For the above use…Regexvar(0).value.trim…

INVOICE NUMBER = (?<=ISSUE DATE\r\n\s+)\w+

ISSUE DATE = (?<=ISSUE DATE\r\n\s+\w+\s+)\w+ 

CUSTOMER CODE = (?<=DUE DATE\r\n.*)\S+(?=\s+\d{2}\w{3}\d{4})

INR = (?<=GRAND TOTAL AMOUNT IN\s?)\w{3}

AMOUNT = (?<=GRAND TOTAL AMOUNT IN.*)[\d.]+

Hope this helps…

3 Likes