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.
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 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.
Remove Row [X]
Remove & Merge Rows Remove specific rows based on the line number.
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 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.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us