Just want one column from table

[mcapodici 0]

Hi

 

I am using the pro version with the scrape table option

 

I want to extract a single column from this and save it to a file.

 

What is the best way to do this?

 

Thanks

 

Martin

[malefic 48]

Off the top of my head I would say scrape the whole table and then save to temp file.

 

Read that file into a list

Loop for the total of the list you just read in

Add to list, use list item to add only the column you want to the new list

Save that file

 

Not tested but think it should work!

[JohnB 255]

I would scrape the table as suggested and then follow up with a loop. In that loop use an "add item to list" (table cell) from the column you want...then save the list to a file.

 

 

John

[Praney Behl 314]

So I guess you have scraped the table already. Now you know the position of this column that you want. You need to run a loop through it and then save it in a table.

 

Here are 2 examples on how you can do it:

 

P.S. Assuming the table name is : 'your_table_name' and column you wish to extract is the first column, hence '0'.

 

Example 1. Without using list:

set(#pos, 0, "Global")
set(#data, $nothing, "Global")
loop while($comparison(#pos, "<", $table total rows(&your_table_name))) {
   set(#data, "{#data}
{$table cell(&your_table_name, #pos, 0)}", "Global")
   increment(#pos)
}
save to file("{$special folder("Desktop")}\\data.txt", #data)

 

Example 2. Using list:

 

set(#pos, 0, "Global")
clear list(%data)
loop while($comparison(#pos, "<", $table total rows(&your_table_name))) {
   add item to list(%data, $table cell(&your_table_name, #pos, 0), "Delete", "Global")
   increment(#pos)
}
save to file("{$special folder("Desktop")}\\data.txt", %data)

 

Hope it helps.

 

Cheers!

 

Praney

[Praney Behl 314]

I would scrape the table as suggested and then follow up with a loop. In that loop use an "add item to list" (table cell) from the column you want...then save the list to a file.

 

 

John

 

LOL you beat me by minute as I was writing the code...

 

Haha

 

Good stuff mate

[theninjamanz 29]

I tried to do this earlier.

 

Scraped an attribute with a wild card which pulled back a list of titles.

 

Then I added that list ot a table as a column row 0, column 0.

 

Then I scraped another item on the page and added that to another list, and then tried to add that list to the table in column 1, row 0.

 

Any idea why what happened when I saved off the table why I got one set of items after another (IE it was just a long list of list A and list .

 

Cheers.

[JohnB 255]

The only thing that comes to mind is make sure you didn't mix up the column and row. It's one of the commands I use frequently and it works very well, so if you want to share your code, I'll be happy to have a look at it. Feel free to PM me if you want to keep it private.

 

John

[UBotBuddy 331]

I have suggested several times in the Enhancement area that we need (at the very least) two additional nodes.

 

1. Add to List from Table Row

2. Add to List from Table Column

 

I would suggest throwing it back to the Enhancement area again. That's all we can do except write more code.

[Guest michelsmith]

Really it's very helpful information thanks for sharing

[adamv 0]

I have suggested several times in the Enhancement area that we need (at the very least) two additional nodes.

 

1. Add to List from Table Row

2. Add to List from Table Column

 

I would suggest throwing it back to the Enhancement area again. That's all we can do except write more code.

 

I would love to see those additions. It would be so much easier than doing it the way mentioned above and I have found myself wishing I could create a list from a table column many times.

[junk 0]

Through running a loop you can do it and save it in a table. In addition to this you can add to list from the table and add to list from the table column. It will be helpful for you.

Thanks