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 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.
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 Conver To Table Rows filter.

Filter Category Description
Keep Rows Where ... Remove & Merge Rows Filters rows based on specific terms, data type, or with regex.
Keep Table Section 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
Remove & Merge Rows Groups data spanning multiple rows together based on the line structure.
Identify Subsections
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 an unneeded column.
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 sets 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.
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.

Still need help? Contact Us Contact Us