DOCPARSER FILTER REFERENCE
Refine your parsed data with filters
Docparser provides a range of filters for extracting, cleaning, formatting, and transforming your parsed data. Filters are available for both text-based results and table outputs.
TEXT OUTPUTS
Text filters
Available when using a text-based preset or when converting a table output to text.
Crop From Start & End
Control where your extracted result begins and ends.
Search, Replace & Add
Modify existing text or add new information to the result.
Format & Refine Results
Clean and standardize your parsed text.
More Filters
Specialized filters for extracting and transforming data.
| Filter | Category | What it does |
|---|---|---|
| Define Start Position | Crop From Start & End | Define a keyword to mark the beginning of your data. |
| Define End Position | Crop From Start & End | Define a keyword to mark the end of your data. |
| Search & Replace | Search, Replace & Add | Search for simple text or use Regex search and replace actions. |
| Insert Text | Search, Replace & Add | Insert a string of text at the beginning or end of your parsed result. |
| Insert File Meta-Data | Search, Replace & Add | No description provided. |
| 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, including international numbers. |
| Find & Format Dates | More Filters | Extracts only dates and provides the capability to convert them to other date formats. |
| Convert Week Number to Date | More Filters | No description provided. |
| Find Email Addresses | More Filters | Lists all email addresses present within the document. |
| Find Word Count | More Filters | Returns 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 such as Street, City, and Postal Code. |
| Set Fallback Value | More Filters | Outputs a predefined value if no data is found. |
| Set Static Value | More Filters | No description provided. |
| Convert To Table Rows | More Filters | Converts parsed data from a text output to a table and allows the use of Table Filters. |
| Find Repeating Text Blocks | More Filters | Search for blocks of repeating data based on starting and ending keywords. |
| Summarize Data as | More Filters | Use AI to summarize your document. |
| Parse XML Data | More Filters | No description provided. |
| Parse UBL Document | More Filters | Parse UBL formatted files. |
| Custom Dictionary | More Filters | Create a dictionary of terms common in your documents. |
TABLE OUTPUTS
Table filters
Available when using Line Items, Table Data, or another table-based preset, as well as when using the Convert To Table Rows filter.
Add, Remove & Merge Rows
Control which rows are included and restructure groups of rows.
Alter Column Structure
Add, remove, split, merge, and reorganize columns.
Fill, Replace & Overwrite
Modify or populate existing table cell content.
Format Cell Content
Clean and standardize values within table cells.
Table Conversion
Change the overall structure or output format of a table.
| Filter | Category | What it does |
|---|---|---|
| Keep Rows Where ... | Add, Remove & Merge Rows | Filters rows based on specific terms, data type, or Regex. |
| Remove Rows Where... | Add, Remove & Merge Rows | Remove rows based on specific terms, data type, or Regex. |
| Remove Row [X] | Add, Remove & Merge Rows | Remove specific rows based on the line number. |
| Keep Table Section | Add, Remove & Merge Rows | Isolate or keep a section of a table based on beginning and end search terms. |
| Remove Table Section | Add, Remove & Merge Rows | No description provided. |
| Group & Merge Rows | Add, Remove & Merge Rows | Groups data spanning multiple rows together based on the line structure. |
| Insert Row | Add, Remove & Merge Rows | No description provided. |
| 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 | No description provided. |
| Keep Columns [X] To [Y] | Alter Column Structure | Specify a column range to keep. |
| Remove Columns Where ... | Alter Column Structure | No description provided. |
| Remove Columns [X] to [Y] | Alter Column Structure | No description provided. |
| Remove Empty Columns | Alter Column Structure | Automatically removes columns that contain no data in any rows. |
| Split Column | Alter Column Structure | Split a column automatically or based on keywords, words, or characters. |
| Merge Columns | Alter Column Structure | Join one or more columns together into a single column. |
| Calculate a New Column | Alter Column Structure | Performs mathematical functions across columns and creates a new column containing the output. |
| Insert Column | Alter Column Structure | Insert an empty column for use with copying or fill-column filters. |
| Search & Replace Text | Fill, Replace & Overwrite | Search and replace simple text terms or use 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 replacement options. |
| 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. |
| Convert Week Number to Date | Format Cell Content | Convert a 2-digit week number into the start date for a given year. |
| 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 | No description provided. |
| Summation from Column | More Filters | Perform simple SUM calculations on all rows in a specific column. |