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

  1. Double-click or drag the Read action from the CSV/TXT node in the Actions palette.
  2. Enter the name of the session that you have used to open the CSV or text file in the Open action.
  3. 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.

Next steps

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