Articles → AUTOMATION ANYWHERE → Read CSV File Using ‘Read From CSV Text’ Command In Automation Anywhere 10.5

Read CSV File Using ‘Read From CSV Text’ Command In Automation Anywhere 10.5

In this article, we will see how to read CSV file using ‘Read From CSV/Text’ command in automation anywhere

Example

First, create a CSV file with some sample data. We are using following file.

Click to Enlarge

Next step is to drag and drop ‘Read From CSV/Text’. Once you do that, following window will come

Click to Enlarge

Following code gets added.

Picture showing the code of the Read From CSV/Text command

Click to Enlarge

As you can see in the code above, a loop gets added automatically. Next step is to add a message box to display the result.

In the message box, you can add variable ‘field column1’ and ‘field column2’.

Picture showing the message box activity to show the value of the CSV columns

Click to Enlarge

Save it and run the task. You will get following output

Picture showing the output of Read From CSV/Text command

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Wednesday, September 26, 2018

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**