- 3 minutes to read

Formula - CSV

Easily extract values from any CSV structure using the Nodinite csv Formula plugin. This page shows you how to transform delimited message content, context values, or results from other formulas into usable data for your integrations.

✅ Extract data from CSV or delimited text with a single formula
✅ Use flexible parameters for delimiter, column, and row skipping
✅ See clear, real-world examples with input, formula, and result

What does the csv Formula do?

The csv(SkipRowsCount, Delimiter, ColumnIndex, Quote, Content) Formula function extracts values from delimited text, such as CSV files. You can specify which rows to skip, which delimiter to use, which column to extract, and which character marks comments or quoted fields.

Example 1: Extracting a Column from Message Body

Input

"face","suit","value"
"king","spades","13"
"queen","spades2","12"
#"jack","spades3","11"
"ten","spades4","10"

Formula Expression

csv(2, ',', 1, '#', body)

Result

spades2
spades4

Example 2: Extracting a Value from Message Context

Suppose you have a message context value with the key Ids containing CSV content.

Input

"face","suit","value"
"king","spades","13"
"queen","spades2","12"
#"jack","spades3","666"
"ten","spades4","10"

Formula Expression

max(csv(1, ',', 2, '#', context('Ids')))

Result

Example 3: Extracting from a JSON Field

You can use the result of another formula function as input. For example, extracting CSV content from a JSON field:

Input

{
  "name": "JSONFile",
  "description": "TestFile",
  "content": "\"face\",\"suit\",\"value\"\n\"jack\",\"spades3\",11\n\"ten\",\"spades4\",10\n\"nine\",\"spades5\",9\n\"eight\",\"spades6\",8\n\"seven\",\"spades7\",7"
}

Formula Expression

csv(4, ',', 1, '#', jsonpath('$.content', body))

Result

spades6
spades7

Features

Extract data from any delimited text, including CSV
Flexible parameters for skipping rows, choosing delimiter, column, and quote/comment character
Works with message body, context, or results from other Formula functions
Ensures data integrity across integrated systems

Important
The csv plugin loads the entire message into RAM. Only use this function on small messages to avoid performance issues.

How to use the csv Formula

Select Formula as the expression type plugin.
Enter your csv expression in the 'Expression' text area.
Provide a delimited string as the Content parameter (e.g., message body, Context value, or another formula result).

Syntax

Extract from message body:
csv(SkipRowsCount, Delimiter, ColumnIndex, Quote, body)
Extract from message context:
csv(SkipRowsCount, Delimiter, ColumnIndex, Quote, context('MessageContextKey'))
Extract from another formula:
csv(SkipRowsCount, Delimiter, ColumnIndex, Quote, SomeOtherNestedFormulaFunction(Content))