How do I move data from a list format to table format?

[Casman33]

If I have a large number of records listed in one column with (10) attributes, how do I convert the file such that I have a database or excel sheet with all the records in separate columns? File example attached.

Thanks for the help.

Mark

[forumsupport]

Hello,

Transferring data between two applications or importing data into any application is one of the popular usages of Automation Anywhere.
Using Automation Anywhere 4.0, you can transfer data from any application to any other application. For example, Transfer data from Excel to a webpage or from webpage to the Excel, or transfer data from Excel to a database, etc.

You can use 'Excel’ commands that works tightly with excel to perform routine functions like Go To cell, get cells, run excel macro etc. You can use ‘Excel-Open Spreadsheet’ command to open the excel spreadsheet in which want to entered the data, ‘Excel-Go to Cell’ command to go to the particular cell in the spreadsheet and use the ‘Excel-Set Cells’ feature to insert the data or formula in spreadsheet.

You can view demo on Excel commands usage from, http://www.tethyssolutions.com/AAExcelIntegration.html

For better understanding, you can refer to various online examples for Excel integration and data transfer from following links,
http://www.tethyssolutions.com/autom...celintegration http://www.tethyssolutions.com/autom...mples.htm#data

We have also attached sample task file ( MasterCedia.atmn) in attached zip file for your convenience. This task extracts data from Master Cedia 1.xls (Source) to Master Cedia.xls (Destination). This task is for your reference and hence extracts only 3 columns namely CompanyName, Address, Phone. Similarly, you can add commands to extract other columns.

Before running this task please follow below mentioned instructions carefully:
1) Copy MasterCedia.atmn under location, My Documents\Automation Anywhere\Automation Anywhere\My Tasks.
2) Copy Master Cedia 1.xls and Master Cedia .xls under c:\
3) Set Repeat property of task according to your requirement. For e.g. if you want to extract 5 records from Master Cedia 1.xls (Source) then specify 5 in Repeat property. You can find Repeat tab under Properties window at bottom of main screen.

Hope that helps. If not, then If you can give us your contact number then we can call you to help you explain the solution. Alternatively, you can reach us at following numbers
USA: 1-888-484-3535 X 3
International: +1-408-834-7676 X 3