Automation Action: Parse CSV Line
Extract column data from a comma separated text value.
Extract values from comma separated text.
Select the CSV value to parse from the Parse CSV Line In list.
In the Column Assignments grid, for each column you want to extract enter the Column Number and select the Assign Value To variable to receive the column value.
Column numbers are 1 based.
This action will correctly handle quoted values.
This action is useful when used with the For..Each loop, looping on Line. This enables you to read a CSV file (or Attachment) and loop on each line. Inside the loop use this action to parse each CSV line.