How to read jsut a column from a file list

[Jor1s]

Hi

Like i said in my previous post, i'm trying to make a template to analyse a list of urls which i automatically download.
Files are CVS with many informations and only A column is interesting me.

The fact is i need to get File path with directory (to choose 1 by one each CSV) and then i need to read the selected CSV but only A column.

Actually i am using READ file, but it read all the columns.

Maybe i need to prepare text ? remove unused columns etc ?

Thx

 

[Mankush]

Use "Table". then "read cell". then just choose column A.

 

[Jor1s]

Of course i tryed that but Read Cell msut be associated to a FILE and here the main problem is i need to read A column from Many and many files

 

[Mankush]

You can try and use Var instead of file name in table "from a file". might work.
If I understand you are scraping content. then saving to a file.
So, you can double loop:
First loop - inside table itself - just for cell A - loop through the lines.
Then - loop again with the next file etc etc....

 

[Jor1s]

You can try and use Var instead of file name in table "from a file". might work.

If i understand you tell me to put a variable in table path ? Then it will grab random table ?

Here a screenshot, and it don't work :/

If I understand you are scraping content. then saving to a file.
So, you can double loop:
First loop - inside table itself - just for cell A - loop through the lines.
Then - loop again with the next file etc etc....

Yes it what i would like to do, but my first problem is to extract only A column from tables. (A columns contain domain to analyse, other columns are details i don't care actually)

 

[rostonix]

You cannot use variables in tables/lists settings.
You have to use bind to file action.
http://zennolab.com/discussion/showthread.php?6628-Simple-example-actions&p=37478&viewfull=1#post37478

You can start loop and increase number on each iteration which you can use in read cell action:

 

[Jor1s]

Well i don't really understand how i need to build it ?

Could you please explain it a bit more ? Many thanks

 

[Jor1s]

i guess no :s