Hi,

Had scratched my head to build a custom rule in Java for extracting the tabular data from the text files I have.

A sample of the data is as follows:
________________________________________________________________
tr style="background-color: #eee"
tdbAlexa Rank:/b/td
td4,381/td
/tr
tr
tdbLink Popularity:/b/td
td6/10/td
/tr
_______________________________________________________________

I have built the following JavaScript source for doing this but its incomplete. Can you help me in completing this code:

DataExtractor.SetColumns(1);
DataExtractor.AddHeader(1, 'Alexa Rank:');
DataExtractor.AddHeader(1, 'Link Popularity');


var mt = (document.getElementsByID('myTable').rows[0].innerHTML);


if (mt.length 0) {
for (i=0; imt.length; i++) {
DataExtractor.StartNewResult();
DataExtractor.AddResult(1, mt[i].Alexa Rank);
DataExtractor.AddResult(1, mt[i].Link Popularity);
}
}

Thanks in advance!

Regards,
Vani

Vani,

Sorry you're having problems, you should try using the following method, I have not tested it but we often use a similar approach when creating rules:

var cells = document.getElementsByTagName('TD');
var nextRow = -1;
for (var i=0; icells.length; i++) {
obj = cells[i];

//Check for real data and enter it in correct place
if (nextRow -1) {
DataExtractor.AddResult(nextRow, obj.innerText);
nextRow = -1; //reset row counter
}

if (obj.innerText.trim() == 'Alexa Rank:') {
nextRow = 1;
}
if (obj.innerText.trim() == 'Popularity:') {
nextRow = 2;
}
}


For full rule creating you can use our service here:

http://www.iconico.com/Da...mRule.aspx

Hello Nico,

Thanks for the sample code, i did try it, But on using that in Data Extractor to extract the td data. I got the following message:

There is an error in "icells"

I think this line in the source has a problem:
for (var i=0; icells.length; i++)

Can u help sort it out. I'll be thankful to you.

Kind Regards,
Vani

You need a less than sign after the "i". Our online forum strips out less than and greter than signs.