Loop from File, variables?

[DavidCAllen]

Good Moring

Having read the help files I have a basic understanding of the Loop from File process, my question is in relation to variable values to be gained from each file in per iteration?

I would like to have the following variables:

Position=
Barcode=
Serial=
Name=

Each text file will have the values to these variables, for example:

Text File 1

Position=40
Barcode=123456
Serial=787890
Name=Device1

I would like the Loop section of the automation to on each loop get its values from the text file.

Is this possible? And if it is would you be able to give a quick example or explanation.

Many thanks

David

[forumsupport]

Hello,

Using Automation Anywhere you can automate data transfer, data Import/Export, etc. Transferring data between two applications or importing data into any application is one of the popular usages of Automation Anywhere. Using Automation Anywhere, you can transfer data from any application to any other application. For e.g. Transfer data from Excel to a webpage or from webpage to the Excel, or transfer data from text files to a CSV file, etc.

You can refer to various online examples for data transfer from following link, http://www.tethyssolutions.com/autom...mples.htm#data

In addition, for your reference, we have attached a sample task that transfers data from all the text files in a folder say C:\Temp into a CSV file. Please extract .txt files in an attached zip file under C:\. It would automatically create ‘Temp’ folder under C:\. Please copy attached .atmn file under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.

Before running this task, you need to create four variables namely $Position$, $Barcode$, $Serial$ and $Name$ through Variable Manager.

To create variable please follow below mentioned steps,

1. Go to Tools->Variable Manager in Automation Anywhere.
2. Click on “Add New Variable”.
3. From "Type" dropdown, select "Value".
4. In “Name” field, enter “Position”.
5. In “Value” field enter any value say '0'.
6. Press “Save”. Press “Ok”
7. Similarly create remaining three variables.

Hope that helps.

[DavidCAllen]

Works a treat many thanks