Forum rulesBefore asking a question or reporting an issue:1. Please review the list of FAQ's.2. Use the Google search box (at the top of each forum page) to see if a similar problem or question has already been addressed. This will search the entire contents of the forums as well as the iMacros Wiki.3. We can respond much faster to your posts if you include the following information:

Yep, there is always a way in iMacros (and usually more than one), ah-ah...!

Before I give you some possible Solutions, I would like to know the Reason why you want to extract the Data from this Table Row by Row...?Is is because of (1) Speed or is it because of "Maintenance Headache" (2) with all those 'POS=n'...?Or is it because, not shown in your Script what you do with all those Extracts, but I reckon you save the Data to some '.CSV' File with 'SAVEAS'...?, and indeed, your Data will currently be saved in one big Row with 30 Cells (3).

If it is because of (3), you need to insert a 'SAVEAS' every 6 Extracts at the end of each Row:

Now for Reason (2), for Maintenance Ease, if you want to quickly be able to modify your Script to add/remove Rows, you can use Relative Positioning as you've already managed to identify the first Cell of each Row with an "easy" 'TAG POS=1' / 'TAG POS=2' / etc... for each Row:

Well, I hope this answers your Qt, give more Details otherwise on why and what you want exactly and what the Pb is...?

>>>

Oh...!, and your Thread Title is not very-very usefully Descriptive, only the Term "Table" is relevant, as all Threads on this Sub-Forum are about "Extract Data from a...", a better Thread Title could be: "TABLE: Extract Data Row by Row?". (You can still edit your Post and your Thread Title...)(A Descriptive Thread Title is important for other Users searching the Forum with a similar Case/Question to know what a Thread is about without having to read the whole Thread...)

- (F)CIM = (Full) Config Info Missing: iMacros + Browser + OS with all 3 Versions...- I usually don't even read the Question if that (required) Info is not mentioned...- Script & URL usually help a lot for a more "educated" Help...

Thank you very much for a detail explanation on how to extract data from a table.You are right I did not mention clearly how I want to extract the data.My initial wish is to extract data row-by-row to speed up the process as you explain in the first 2 examples.But when you show the third option which could extract data as a whole, then this is really what I want but I did not know that iMacros could handle that.

I have another question though, in the example #2 that you show me, is there a way kind like looping so that you could enter a block of data once and start the execution from the beginning of that block like this:

pandax wrote:Thank you very much for a detail explanation on how to extract data from a table.You are right I did not mention clearly how I want to extract the data.My initial wish is to extract data row-by-row to speed up the process as you explain in the first 2 examples.But when you show the third option which could extract data as a whole, then this is really what I want but I did not know that iMacros could handle that.

I have another question though, in the example #2 that you show me, is there a way kind like looping so that you could enter a block of data once and start the execution from the beginning of that block like this:

OK, good to hear that 'TYPE=TABLE' was actually what you were looking for, and this is actually the "Standard" way to extract Tables.It doesn't always work, on complex Pages for example with several Tables, then it can be tricky to find out which one is "your" Table, or if you don't want all the Data from the Table.Hum, and that Example was Example #4 from my Post, not #3.

... Just like your "Example #2" was "Example #3" in my Post...But yep, to only use one Block of Code to extract 1 Row and to loop the Script with the 'Play (Loop)' Button from the iMacros Side-Panel, you can easily adapt the Script to base it on '!LOOP':

=> If you want to extract the first 10 Rows of Data, you simply specify "10" in the 'Max' Field and you loop the Script 10 times.(I have btw disabled the 'URL GOTO' Statement which would otherwise load the Page 10 times (for each Loop), which usually takes the longest time, it is better to first load the Page manually...)

Now if you only wanted to extract/save Row #7 for example, you simply edit the Macro with "SET !LOOP 7" and using the 'Play' Button, the Script will extract and save only Row #7.

If you want to extract and save the 3 consecutive Rows #7 until #9, still with "SET !LOOP 7", but you need to specify "9" in the 'Max' Field because otherwise, iMacros will only handle the first Row (=Row #7).

(Because when looping a Macro, iMacros reads the "SET !LOOP n" Statement only on the first Loop to know from which Row (usually when taking Data from a DataSource) it has to start, and it does the +1 Increment automatically for the following Loops until it has reached the 'Max' Value.)

And don't forget after running/looping your Script for Rows [7-9] to edit your Script again with "SET !LOOP 1", otherwise if you forget, next time you want to extract Rows [1-10], it will then only extract Rows [7-10], ah-ah...!

- (F)CIM = (Full) Config Info Missing: iMacros + Browser + OS with all 3 Versions...- I usually don't even read the Question if that (required) Info is not mentioned...- Script & URL usually help a lot for a more "educated" Help...

- (F)CIM = (Full) Config Info Missing: iMacros + Browser + OS with all 3 Versions...- I usually don't even read the Question if that (required) Info is not mentioned...- Script & URL usually help a lot for a more "educated" Help...