Skip to main content
Docs
Go to the Studio
Roberty Studio
RPACSV

For each column in CSV file

For each column in CSV file

Goes through every column of a specific row of a CSV file, running a block of actions for each column. Ideal for processing data laid out in columns within a CSV row.


Options​

CSV file​

Select the CSV file already read by a CSV file reading action. The field lists the CSV files available in the flow.

Current line​

Select the For each row in CSV file action that contains this action. The current row of that action is used as the reference to go through the columns.

Worksheet initial column​

Enter the number of the column where the iteration starts. Columns are counted from 0 (first column of the file).

Final column of CSV file​

Enter the number of the column where the iteration ends. This column is also processed.

Returns​

Javascript code​

js
actions["action-id"].currentColumn  // current column position (Number)

Field selection​

  • currentColumn — current column position (Number)

Rules and Conditions​

  • The CSV file, Current line, Worksheet initial column and Final column of CSV file fields are required.
  • This action must be used inside a For each row in CSV file block.