Automation Action – Parse CSV Line | ThinkAutomation

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.

This is one action from over 180 actions included with ThinkAutomation. The ThinkAutomation business process automation (BPA) solution is designed to automate on-premises and cloud-based business processes that are triggered from incoming messages. Automate messages received by email, database updates, webhooks, web forms, web chat, SMS messages, Twitter, Teams messages, documents, local files and other messages sources. Create any number of workflow automations using the drag-and-drop low-code designer. Simple fixed pricing, with unlimited message processing reduces overall costs compared to hosted automation solutions.

You can also extend ThinkAutomation by creating your own custom automation actions using the built-in designer and C#/VB.net code editor.

Download Free 30 Day Trial

Back To Automation Actions List

ThinkAutomation Home