I have configured the java code to extract page title, all the meta tags, and text I have contained in my webpages to a spreadsheet or database format.

The problem I have now is the results format.
I want to have a number of columns that contain each section of information.
For example column 1 is the page title, C2 is the meta name description, C3 is the meta name keywords etc.

What I want is for every web page extracted for all the information to be contained onto one row. I do not want it separated onto 2,3,4 different rows.
All the page information must be kept onto one row then the following row will contain the next webpage.

Could you please help.
I have tried a number of various ways but with little result
Craig

It should be very easy, just do:

DataExtractor.SetColumns(3);
DataExtractor.AddHeader(1, 'header1');
DataExtractor.AddHeader(2, 'header2');
DataExtractor.AddHeader(3, 'header3');

DataExtractor.StartNewResult();
DataExtractor.AddResult(1, 'data1');
DataExtractor.AddResult(2, 'data2');
DataExtractor.AddResult(3, 'data3');

replace 'data1' etc with your real data.

This is the format that I have written the javascript.
This method does extract the results that I want. The problem is that I want the results displayed with all the information for each page placed in a single row per result.
The problem is that when I run the process, instead of having the result on one line they appear as follows:

Title Meta Name Meta content
page title 1 description meta description here
page title 1 keyword meta keywords here
page title 1 author joe blogs

What I need is this format

title meta desription meta keywords meta author
page 1 meta descrip 1 keywords for page 1 author page 1
page 2 meta descrip 2 keywords for page 2 author page 2

I can extract the data it is just trying to re-fornat the data to the format above that i require.

By the way thanks for the quick response

I see what you are trying to do. You would have to change the rule to loop over the meta tags, you can use a "for" loop in javascript. Look for the description and add that to column 2, the keywords and add that to column 3 and the author and add that to column 4.

How would you go about using the For command as I have heard about it but never used it, I had consider trying to use the if command but each time i tried this method I would end up with the word after the if command being placed in all the column fields.
Could you give an example on one the the fields please

I don't really have time to go in depth, but start here:
http://www.w3schools.com/...op_for.asp

I take it you are trying to say to use the For command to run the program once gathering the data and then to stop the program once it reaches a determined value.
I am abit confussed about how the for command can be applied?

Craig, without writting the rule for you I don't really know how to explain it any better.

You would have to change the rule to loop over the meta tags, you can use a "for" loop in javascript. Look for the description and add that to column 2, the keywords and add that to column 3 and the author and add that to column 4.

I have written the code which starts by setting the columns up and adding the headings in to each.

I have then written a varialbe command to get the meta tags and stated that if the meta length is present to run a program.

I have now inserted a for command which then using the data extract and addresult commands gets the data.

But I am still getting the data in column result format rather than each page on each row.

I will put the code up so that you can see what it looks like

Dataextractor.setcolumns (3);
dataextractor.addheader(1, 'title');
And so on to set the column headers

var meta=document.getelementsbttagname ('meta');
if (meta.length 0) {
for (i=0; imeta.length; i++) {
Dataextractor.startnewresult();
dataextractor.addresult (1, document.title);
dataextractor.addresult(2, meta[i].name);
And so on for all relevant data collection

But it still produces a column rather than row format

move the startnewresult out of the loop and put it before it.