Using Read action

Use the Read action to retrieve values from a CSV or TXT file, and insert them into a Table variable to perform operations with the data values.

Note:

The Read action only support CSV/TXT files that conform to the RFC 4180 standard. For more information about the standard, see Common format and MIME type for CSV files.
When you use the Read action to read data from a CSV or TXT file that contains double quotes, the bot might display an error message: Unable to read the file and create a table. We recommend that you replace all double quotes with an empty or a blank character.

To retrieve values from a CSV or TXT file, do the following:

Procedure

Double-click or drag the Read action from the CSV/TXT node in the Actions palette.
Enter the name of the session that you have used to open the CSV or text file in the Open action.
Select a Table variable from the Assign value to the variable list.
Create a variable if it does not already exist. The Control Room shows a descriptive default variable name. If you create several output variables, subsequent variable names are appended with a -1, -2, -3, and so on to avoid duplication.

Note: A bot can return only a maximum of 3 MB to an output variable.
Workaround: Store the bot output on the device, such as in a .txt file. If the output must be shared across multiple Bot Runners, store the output in a shared drive.

Perform operations with the values in the Table variable using the Data Table package.