Skip to main content

How do I use the Calculate a New Column Filter?

If you need to create a column using data from an existing column, you can use the Add Table Filter > Alter Column Structure > Calculate a New Column filter:

Docparser interface showing Calculate a New Column filter option under Alter Column StructureIn order to cite a column you wish to work with, you can either use default 'Col #' or the custom column names you use via the Add Table Filter Alter Column Structure Name Column Headers filter:

Example of using default column names like Col #1 in Docparser formula editorUsing default column names

Example of using custom named columns in calculation formula in Docparser

Using named columns

This filter is flexible and supports all basic math operations, addition (+), subtraction (-), multiplication (*), and division (/), and supports order of operations by using parenthesis in your calculation:

Screenshot of calculation syntax in Docparser using parentheses and math operations

If you have any questions or run into trouble getting set up please reach out to us at support@docparser.com

 

How to Calculate a New Column:

Was this article helpful?
0 out of 1 found this helpful

Still stuck?

Send us your parser name and a sample document.

Submit a request