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. |
Insert File Meta-Data | Search, Replace & Add | |
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. |
Convert Week Number to Date | More Filters | |
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. |
Set Static Value | More Filters | |
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. |
Parse XML Data | More Filters |
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. |
Remove Row [X] | Add, Remove & Merge Rows | Remove specific rows based on the line number. |
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. |
Remove Table Section | Add, Remove & Merge Rows | |
Group & Merge Rows | Add, Remove & Merge Rows | Groups data spanning multiple rows together based on the line structure. |
Insert Row | Add, Remove & Merge Rows | |
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. |
Keep Columns Where ... | Alter Column Structure | |
Keep Columns [X] To [Y] | Alter Column Structure | Specify a column range to keep. |
Remove Columns Where ... | Alter Column Structure | |
Remove Columns [X] to [Y] | Alter Column Structure | |
Remove Empty Columns | Alter Column Structure | Automatically removes any columns that contain no data in any rows. |
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. |
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. |
Format As | More Filters |