How do you iterate through an Excel document or other source of input to input variables

Reply •Thanks • 2014/11/29 04:10:01 0 0

I have a list of searches I want to iterate through and go to the web pages.

Then I want to extract some data for research from each web page and write it to a text or excel file. Is this possible with this software?

Augustrain

2014/11/29 09:42:26

use "write file"

WhiteHatBox

2014/11/30 06:37:07

yes, no problem. put your url list into a table variable , then use loop action to visit them one by one and scrape them one by one, then write the result into file.

Let's ROCK!

kushblends99

2016/07/10 10:04:26

I'm trying to do something similar, where I have a 100,000 line .txt file. I would like to read from the file butonly use 1,000 lines. Then I would like to remove the same 1,000 lines I used from the 100,000 line .txt file. Is this possible to do in botchief? Thanks for your time and consideration. :)

Aprilcaicai

2016/07/11 00:15:33

4 # kushblends99 7/10/2016 10:04:26 AM
I'm trying to do something similar, where I have a 100,000 line .txt file. I would like to read from the file butonly use 1,000 lines. Then I would like to remove the same 1,000 lines I used from the 100,000 line .txt file. Is this possible to do in botchief? Thanks for your time and consideration. :)

1. Put your txt file into a csv file.
2. Add a Read file, and then read your txt file to a Table variable table 1.
3. Add a Loop command to read the front 1000 lines out, and then save them to a Table variable table 2, also delete them from table 1.
4. Write the value from table 1 to overwrite the original content in the csv file.
You can edit some steps according to your needs.

<< < 1> >>

Please input report reason: