Hi,
I have a HTML table that i need to extract data from. The table does not have a fixed set of rows and columns. Depending on the input entered by the user, the results in the table varies from a single row-single column to at least 2 rows and 3 columns. I will need to extract data from one of these columns. Please advise how to proceed.
Thank you,
I have a HTML table that i need to extract data from. The table does not have a fixed set of rows and columns. Depending on the input entered by the user, the results in the table varies from a single row-single column to at least 2 rows and 3 columns. I will need to extract data from one of these columns. Please advise how to proceed.
Thank you,
8 Answers, 1 is accepted
0
Daniel
Top achievements
Rank 2
Rank 2
answered on 14 Jan 2014, 02:47 PM
Which column, if it existed, would you be extracting from?
0
Mercedes
Top achievements
Rank 1
Rank 1
answered on 14 Jan 2014, 02:59 PM
In the screenshots i attached, the lower one says "No Surcharges found". I will need to extract that and If instead i see the first screenshot, i will need to extract the value in the 3rd column (which is the amount associated)
0
Mercedes
Top achievements
Rank 1
Rank 1
answered on 14 Jan 2014, 04:11 PM
I think we found a way for this, We used Verify Exists and then extracted the values conditionally. Thanks for the help.
0
Daniel
Top achievements
Rank 2
Rank 2
answered on 14 Jan 2014, 07:38 PM
Glad you found your answer. Sorry I wasn't able to respond quick enough. Have a good one.
0
Hi Brian,
We are glad that you have found a solution.
If you need additional assistance, please do not hesitate to contact us.
Regards,
Boyan Boev
Telerik
We are glad that you have found a solution.
If you need additional assistance, please do not hesitate to contact us.
Regards,
Boyan Boev
Telerik
0
Sam
Top achievements
Rank 1
Rank 1
answered on 28 May 2014, 07:37 PM
Question: How do I extract a value from the Session Data then save it into Local Data or some kind of excel file/csv/txt?
I was not quite clear on how to approach this prior...I am attempting to extract a value ("rx_id":23624 the numeric value) from the page source array. Then place it into either some kinda of local data or export and excel file.
I found this script for a coded extraction...
Get/Set Extracted Variables in Code
PROBLEM
I extracted a variable in a test step. I would like to do something with that data in a coded step.
SOLUTION
Use the GetExtractedValue() function:
//object myData = GetExtractedValue("varname");
So I changed it to the following (note I am not a programmer so if you need something else, let me know)...
var step_data = GetExtractedValue("rx_id");
Now...is that saving it correctly? (if so) how can I now export that
value to a excel or local data so I can run all my tests...it saves the
RX_ID (which is unique for each test) and place that into some file we
can refer back to for a report.
Any thoughts?
I was not quite clear on how to approach this prior...I am attempting to extract a value ("rx_id":23624 the numeric value) from the page source array. Then place it into either some kinda of local data or export and excel file.
I found this script for a coded extraction...
Get/Set Extracted Variables in Code
PROBLEM
I extracted a variable in a test step. I would like to do something with that data in a coded step.
SOLUTION
Use the GetExtractedValue() function:
//object myData = GetExtractedValue("varname");
So I changed it to the following (note I am not a programmer so if you need something else, let me know)...
var step_data = GetExtractedValue("rx_id");
Now...is that saving it correctly? (if so) how can I now export that
value to a excel or local data so I can run all my tests...it saves the
RX_ID (which is unique for each test) and place that into some file we
can refer back to for a report.
Any thoughts?
0
Sam
Top achievements
Rank 1
Rank 1
answered on 29 May 2014, 02:28 PM
Sorry re commenting so i can track this.
0
Hello Sam,
Thank you for contacting us.
Please elaborate a bit more what exactly do you want to store in a variable?
Unfortunately script tag is a special html element which has no ID, no attributes which we use to locate the the elements. The only way to locate this element is via tagIndex (i.e. the first or second, etc script element on the page).
You can also store the entire text within this script tag, not only the second row.
First you should find this script like this:
It will find the 6th script tag on the page for example.
Then you should save its text into a variable:
Here is how you can use it:
Hope to this helps.
Regards,
Boyan Boev
Telerik
Thank you for contacting us.
Please elaborate a bit more what exactly do you want to store in a variable?
Unfortunately script tag is a special html element which has no ID, no attributes which we use to locate the the elements. The only way to locate this element is via tagIndex (i.e. the first or second, etc script element on the page).
You can also store the entire text within this script tag, not only the second row.
First you should find this script like this:
Element script = ActiveBrowser.Find.ByExpression("tagName=script", "tagIndex=script:5");It will find the 6th script tag on the page for example.
Then you should save its text into a variable:
string scriptText = script.InnerText;SetExtractedValue("variableName", scriptText);Here is how you can use it:
GetExtractedValue("variableName");Hope to this helps.
Regards,
Boyan Boev
Telerik