How to Parse Invoice Table with Empty Columns using PDF.co Document Parser

Parse Invoice Table with Empty Columns

Go to your PDF.co Document Parser
Create a New Template
Load Test PDF or Image
Add Objects
Set Object Expression and Properties
Run Template
Result
Save Template

Through this step-by-step tutorial with screenshots, you will learn how to parse invoice tables with some empty columns using PDF.co’s Document Parser.

We prepared a sample invoice that we’re going to use for this tutorial. Find more tutorials about invoice data extraction here.

You must first log in to your PDF.co account here.

Step 1 – Go to your PDF.co Document Parser

On your PDF.co dashboard, click the document parser menu to go to your PDF.co document parser page

Step 2 – Create a New Template

To create a new template. Simply click the New Template link on your document parser page

Step 3 – Load Test PDF or Image

Load your test PDF or image to start creating your template

Step 4 – Add Objects

To get the Due Date, Customer Number, and Customer Name. Use the Add FIELD based on TEXT SEARCH object
To get Table Value, use the Add TABLE field based on TEXT SEARCH object

Step 5 – Set Object Expression and Properties

To get the Due Date of your invoice. Set the Expression to Payment Due(?<value>{{SmartDate}})
To get the Customer Number. Set the Expression to Customer Number(?<value>{{LettersOrDigits}})
To get the Customer Name. Set the Expression to Customer Name(?<value>{{SentenceWithSingleSpaces}})

To get the Table Value. Use the following Properties:

{
"start": {
"expression": "CODE{{Spaces}}DESCRIPTION",
"regex": true
},
"end": {
"expression": "NOTHING FOLLOWS",
"regex": true
},
"columns": [
{
"name": "code",
"dataType": "integer"
},
{
"name": "description",
"dataType": "string"
},
{
"name": "qty",
"dataType": "integer"
},
{
"name": "price",
"dataType": "decimal"
},
{
"name": "unit",
"dataType": "string"
},
{
"name": "discount",
"dataType": "decimal"
},
{
"name": "extPrice",
"dataType": "decimal"
}
],
"multipage": true
}