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 both output modes.
Text Filters
Available when using a text-based preset or when converting a table output to text.
Filter | Category | Description | |
Define Start Position | Crop From Start & End | For defining a keyword to mark the beginning of your data. | |
Define End Position | Crop From Start & End | For defining a keyword to mark the end of your data. | |
Search & Replace | Search, Replace & Add | Used to search for simple text or Regex search and replace actions. | |
Insert Text | Search, Replace & Add | To insert a string of text at the beginning or end of your parsed result. | |
Remove Blank Spaces | Format & Refine Results | Remove trailing, multiple, or all blank spaces from a parsed result. | |
Remove Empty Lines | Format & Refine Results | Removes all lines containing no text data. | |
Remove Line-Breaks | Format & Refine Results | Collapses text into a single line. | |
Change Capitalization | Format & Refine Results | Allows for Capitalized Case, all lower or all UPPER. | |
Find Numbers | More Filters | Filters all text to display only numbers. | |
Find Phone Numbers | More Filters | Automatically collects and displays all phone numbers (supports international). | |
Find & Format Dates | More Filters | Extracts only dates and provides the capability to convert to other date formats. | |
Find Email Addresses | More Filters | Lists all email addresses present with the document. | |
Find Word Count | More Filters | Used for returning the number of words in an output. | |
Keyword Based Tagging | More Filters | Display a static output for single or multiple search criteria. | |
Normalize Postal Address | More Filters | Parses addresses into a column structure (Street, City, Postal code, etc). | |
Set Fallback Value | More Filters | Outputs a predefined value if no data is found. | |
Convert To Table Rows | More Filters | Converts the parsed data from a text output to a table and allows for the use of Table Filters. | |
Find Repeating Text Blocks | More Filters | Option to search for blocks of repeating data based on starting and ending keywords. | |
Table Filters
Our table filters are available when using the Line Items, Table Data, or any table-based presets as well as when using the Convert To Table Rows filter.
Filter | Category | Description | |
Keep Rows Where ... | Add, Remove & Merge Rows | Filters rows based on specific terms, data type, or with regex. | |
Remove Rows Where... | Add, Remove & Merge Rows | Remove rows based on specific terms, data type, or with regex. | |
Keep Table Section | Add, Remove & Merge Rows | Provides a way to isolate or keep a section of a table based on beginning and end search terms. | |
Group & Merge Rows | Add, Remove & Merge Rows | Groups data spanning multiple rows together based on the line structure. | |
Remove Row [X] | Add, Remove & Merge Rows | Remove specific rows based on the line number. | |
Identify Subsections | Add, Remove & Merge Rows | Used to isolate subsections of nested tables. | |
Name Column Headers | Alter Column Structure | Allows for the option of naming columns for tabular outputs. | |
Split Column | Alter Column Structure | Split column allows for automatic, keyword, word, or character-based splitting. | |
Merge Columns | Alter Column Structure | For joining one or more columns together into a single column. | |
Calculate a New Column | Alter Column Structure | Performs mathematical functions across columns (horizontal) and creates a new column with the output. | |
Remove Column [X] | Alter Column Structure | Remove/Discard unneeded columns. | |
Remove Empty Columns | Alter Column Structure | Automatically removes any columns that contain no data in any rows. | |
Keep Columns [X] To [Y] | Alter Column Structure | Specify a column range to keep. | |
Insert Column | Alter Column Structure | Used for inserting an empty column - works well with copying or fill column filters. | |
Search & Replace Text | Fill, Replace & Overwrite | Search and replace simple text terms or using regex across one or all columns. | |
Find Pattern Matches | Fill, Replace & Overwrite | Return data matching a regular expression. | |
Copy & Move Cell Content | Fill, Replace & Overwrite | Copies or exchanges cell content across columns with prepending, appending or replacing entirely. | |
Fill Cells With ... | Fill, Replace & Overwrite | Add or set the text of a cell at the beginning or end of pre-existing data. | |
Fill Empty Cells With ... | Fill, Replace & Overwrite | Set empty cells to a static value or the value of the previous row. | |
Fill Cells With Row-Numbers | Fill, Replace & Overwrite | Replaces a column with row numbers. | |
Format Dates | Format Cell Content | Provides the option to convert dates into different formats. | |
Format Numbers | Format Cell Content | Format numbers to manage decimals, thousand separators, and strip currency symbols. | |
Remove Blank Spaces | Format Cell Content | Remove trailing, multiple, or all blank spaces from a parsed result. | |
Change Capitalization | Format Cell Content | Allows for Capitalized Case, all lower or all UPPER. | |
Transpose Table | Table Conversion | Flip a table's columns to rows and vice versa. | |
Convert To Running Text | Table Conversion | Convert the table output to simple text outputs. Useful for results that do not require an array output via webhook. | |