Search results for tables

48 articles found

  • How to parse tables with complex layouts?

    Docparser offers various tools to extract table data from PDF and scanned documents. The easiest way to extract tables is to use our "Table Data" parsing rule preset, or if you are processing

  • How to extract floating tables which do not have a fixed position?

    The default table extraction tool of Docparser allows you to define the horizontal positions of your table columns with only a couple of clicks. This method works great if your tables can be found

  • Identifying Table Subsections

    To include information that is located on your document but is not a column in the line items or table data you are looking to parse, use the filter to Identify Subsections A common use-case for this

  • Transpose Table Filter

    What is it? Transpose Table essentially transforms rows into columns and columns into rows. This can be very useful if the table you are looking to extract is arranged vertically. How is it used? Add

  • Keep Table Section Filter

    What is it? The Keep Table Section filter is used for defining the beginning and end of a table you need to capture based on keywords or data types occurring within a specific column. How is it used?

  • Group and Merge Table Rows

    Docparser offers various tools to extract table data from PDF and scanned documents. The easiest way to extract tables is to use our "Table Data" parsing rule preset, or if you are processing

  • Convert to Table Rows Filter

    What is it? The Convert to Table Rows filter converts the parsed data from a standard text output which will include all parsed info in one cell. To a table output that can span multiple rows and

  • Remove Blank Spaces Filter (table)

    What is it? The Remove Blank Spaces filter can be used to clean up the output of your data – especially when capturing data within a sentence or adjacent to a field that contains spaces. How is it

  • Search & Replace Text Filter (table)

    What is it? The search and replace filter is used to replace text either in a standard plain text mode or by using PCRE Regex. How is it used? Add Table Filter > Fill, Replace & Overwrite > Search &

  • How to send table data to Zapier?

    Sending data parsed from PDF documents to Zapier is easy thanks to our Docparser Zapier app. Once Zapier and Docparser are connected, parsed data will automatically be sent to Zapier and can then be

  • How can I extract table rows from a document?

    Extracting tables from documents can be achieved by creating either a Table Rows or Line Items parsing rule. Watch the following screencast which gives a quick overview of how to create a PDF table

  • Are there any limitations in terms of size or page count?

    This is a common question from our clients. Our app was primarily designed to handle "small" documents that are uploaded in PDF or image file format. A typical document for Docparser is a 1-10 page

  • Create your first document parser

    What exactly is a parsing rule? A parsing rule is a set of instructions which tells our algorithms what kind of data you are looking for. For example, you can tell our algorithms that you want to

  • What filters are available in Docparser?

    Docparser has a range of filters available for both text-based outputs and table outputs that provide a versatile way of both extracting and refining results. Below is a full table of filters for

  • Convert to Running Text Filter

    What is it? This filter converts a table of values to a single text-based output that will be reduced to a single column and switches the rule over to text-based rules. How is it used? Add Table

  • How to extract line-items from recurring invoices and purchase orders?

    Extracting line items from recurring PDF Invoices or Purchase Orders is easy with Docparser. Below are the steps you need to take to extract line items. Please note: Our table extraction tool is a

  • Why is my Google Sheets integration sending multiple rows?

    If you are unexpectedly receiving multiple new rows in your Google Sheet from your integration, it probably means that Docparser is extracting multiple data points or table data for each document.

  • How to parse repeating text blocks?

    In general, our PDF table extraction filter does a great for extracting "table like" data. However, in some cases, you are dealing with lists that are built up by complex text blocks. These text

  • How do I use the calculate a new column filter?

    If you need to create a column using data from an existing column, you can use the Add Table Filter > Alter Column Structure > Calculate a New Column filter: In order to cite a column you wish to

  • Remove Empty Columns

    What is it? The remove empty columns filter is perfect for clearing up any unwanted columns. How is it used? Add Table Filter > Alter Column Structure > Remove Empty Columns This filter has no

  • Name Column Headers Filter

    What is it? The Name Column Headers filter is used to specify names for the columns in a tabular output. How is it used? Add Table Filter > Alter Column Structure > Name Column Headers Once this

  • Keep Columns [X] To [Y]

    What is it? The Keep Columns [X] to [Y] filter allows you to specify a range of columns to keep. Any columns not in range will be removed from the final output. How is it used? Add Table Filter >

  • Format Numbers Filter

    What is it? The format numbers filter gives the option to apply digit grouping and to specify the format of the digit separators. How is it used? Add Table Filter > Refine Cell Values > Format

  • Remove Column [X]

    What is it? The remove column filter can be used to remove any single column and can be added as many times as needed. How is it used? Add Table Filter > Alter Column Structure > Remove Column [X] To

  • Insert Column

    What is it? The Insert Column filter provides the option of adding an additional empty column anywhere in your current output. This can be used multiple times and is a great option for outputs that

  • How does the set fallback value rule work?

    If you have a parsing rule that may not always return data, you may want to set a default value that the rule will fall back on if no other data is returned in your rule: When working with table data

  • Merge Columns Filter

    What is it? The Merge Column filter can be used to combine data from one or more columns. How is it used? Add Table Filter > Alter Column Structure > Merge Columns The Merge Column filter has two

  • Find Pattern Matches Filter

    What is it? The pattern match filter provides the option to use regex to trim the results of a column down to only the pattern/text you are looking to retain. How is it used? Add Table Filter > Fill,

  • Fill Cells with Row Numbers

    What is it? This filter simply creates a new column that adds a value for the row number in each cell. How is it used? Add Table Filter > Fill, Replace & Overwrite > Fill Cells With Row-Numbers Once

  • Copy & Move Cell Content Filter

    What is it? This filter's primary uses are for moving or exchanging the positions of entire columns. How is it used? Add Table Filter > Fill, Replace & Overwrite > Copy & Move Cell Content Once this

  • How does Invoice Parsing work with Docparser?

    Our invoice parsing rule presets allow a user to create a fully working PDF invoice Document Parser in a couple of minutes. Our proprietary extraction algorithms are using a mixture of pattern and

  • Why does my parsing rule not return any data?

    When setting up Docparser, you might stumble into a situation when no data is returned by a parsing rule. There are various possible reasons which can lead to such a situation. This article will show

  • Find Email Addresses Filter

    What is it? The Find Email Addresses filter can be used to quickly extract all recognizable email addresses from a document without having to use any additional filters. How is it used? Add Filter >

  • Remove Row [X] Filter

    What is it? Remove Row filter provides the option to remove a specific row based on the line number rather than the Keep Rows Where filter which requires specific data or a data type. How is it used?

  • Split Column Filter

    What is it? The Split column filter can be used to create additional columns based on specific keywords, word count or characters. How is it used? Add Table Filter > Alter Column Structure > Split

  • Fill Cells With Filter

    What is it? The fill cells with filter can be used to append, prepend or set the text of an entire column. How is it used? Add Table Filter > Fill, Replace & Overwrite > Fill Cells With … After

  • Fill Empty Cells With

    What is it? The fill empty cells with filter can be used to populate a column of empty cells with either a predefined value or the values of rows in the same column. How is it used? Add Table Filter

  • Find Numbers Filter

    What is it? The Find Numbers filter works by converting your output to a table and discarding all non-numeric data. This can be very useful when the data you need may be embedded in a block of text

  • How do I process DOCX files?

    How it works We have a lot of import options. The two most basic would be to forward an email with a DOCX attachment to your parser or directly upload the file on the Documents page: Docparser will

  • How can I parse documents with multiple pages?

    Processing documents with multiple pages is easy with Docparser and most of our parsing rule templates are looking at the text of all pages by default.  However, in case you are selecting a specific a

  • How do Advanced Webhooks work?

    Advanced Webhooks are your Swiss Army knife for connecting any HTTP API to Docparser. Once setup, parsed data will automatically be sent to the target URL specified in the settings of your Advanced We

  • How to export parsed data to Microsoft Power Apps

    To create a flow from Microsoft Power Apps first select Create and choose Automated cloud flow. You will be prompted to give your flow a name and then choose the trigger. The trigger can be found by

  • What is a parsing rule and how do I create one?

    A parsing rule is basically a set of instructions that tell our algorithm what kind of data you want to extract from your documents. Typically you will have one parsing rule for each data field

  • How to parse repeating values based on anchor keywords?

    Docparser offers various filters to extract repeating data sets from documents. This article describes how you can extract single repeating text values (e.g. Names, Street Names) from a document that

  • How does the Purchase Order Date parsing work?

    Our "Purchase Order Date" parsing rule preset lets you create a parsing rule capable of detecting and extracting the date of an invoice with only two clicks. Under the hood, a combination of pattern a

  • What are the preprocessing options for documents?

    Docparser comes with a variety of different preprocessing options which are in particular helpful when you are dealing with scanned documents. As a rule of thumb, the higher the quality of your scanne

  • How does the "Invoice Date" preset work?

    Our "Invoice Date" parsing rule preset lets you create a parsing rule capable of detecting and extracting the date of an invoice with only two clicks. Under the hood, a combination of pattern and keyw

  • How to extract data from variable positions?

    Docparser offers many different ways of extracting data from your PDF documents. Depending on your specific use-case, different approaches can be applied to get the data you are looking for.  The most