Use Variables in 'String Manipulation' for 'Occurence'

[trentonponder]

I'm having difficulty with a particular web extraction that is not in a table.

The results appear as follows on the website:

Bob is a child
Bob is a child
Bob is a child

I want to extract each line into a separate Excel row. Normally, I can do this pretty easily by looping through an HTML table, but this is not a table. My solution was to save to Clipboard and then use String Manipulation to save the data to a variable and then set the Excel cell with that variable.

However, there can be up to 100 lines and under 'occurrence' you cannot use variables or I would be able to use a list variable to loop through 1-100 times. Instead I have to copy/paste the code 100 times and use Error Handling to make sure it works.

Is there a better way?

[forumsupport]

Hello,

You can convert Enter key into a variable and use that variable in String Manipulation command to get the data in each row. We have attached a sample task for your reference. To run this task,

. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
.Copy sample.txt under c:\.
. Before you replace Variables.dat file, exit from Automation Anywhere completely even from system tray. Clicking on cross (X) button does not exit from Automation Anywhere completely; it is still running in system tray. To exit from system tray, right click on Automation Anywhere icon, select Exit from context menu. Now, overwrite Variables.dat file located under, 'C:\...\My Documents\Automation Anywhere\' folder.

Hope that helps.

[trentonponder]

Originally Posted by forumsupport

Hello,

You can convert Enter key into a variable and use that variable in String Manipulation command to get the data in each row. We have attached a sample task for your reference. To run this task,

. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
.Copy sample.txt under c:\.
. Before you replace Variables.dat file, exit from Automation Anywhere completely even from system tray. Clicking on cross (X) button does not exit from Automation Anywhere completely; it is still running in system tray. To exit from system tray, right click on Automation Anywhere icon, select Exit from context menu. Now, overwrite Variables.dat file located under, 'C:\...\My Documents\Automation Anywhere\' folder.

Hope that helps.

I don't understand how this works. How do you convert the Enter key into a variable? Is it a system variable? The Enter key is not text in the Clipboard so how does the task pull the data just up until that point?

[forumsupport]

Hello,

To create $enterkey$ variable, please follow below mentioned steps.

. Go to Tools->Task Editor.
. Double click on 'Insert Keystrokes' command.
. From 'Select Window' dropdown in 'Insert Keystrokes' window select 'Currently Active Window'.
. Insert [Enter] from special keystrokes.
. Save the command.
. Now, right click on this command and select 'Convert to Variable' from context menu.
. In 'Convert to a Variable' window specify variable name, enterkey and eventually hit save button.

You are done!