I’m currently working on transposing data from multiple PDF invoices to an Excel table.
“Match” activity with Regex expressions are used to extract different fields on the PDF invoice to the Excel table.
Had problem with one of the invoice fields - “PO Number”, as some invoices’ “PO Number” fields are empty, and my program crashed when it ran into them.
Below is the error message:
Source: Write PO Id (this is the Excel application scope function to write PO Id into Excel table)
Message: Object reference not set to an instance of an object.
Exception Type: System.NullReferenceException
Am thinking of using the IF function (to check if the PO number exists before proceeding) but unsure how to do it. If there are other methods to circumvent this problem, please feel free to share with me. Thanks!