parsing a listing and group elements to make a xls

[bluenotes]

Hello

For parsing a listing to get title, description and date, i did 3 regex and saved as a list for each. How to group thoses lists and produce an xls.

Finally i would like to have : titre;description;date as result.

sorry for my bad english... i'm french:huh:

 

[rostonix]

You can use tables for this task: http://wiki.zennolab.com/doku.php?id=en:table

 

[bluenotes]

I looked around (wiki, threads and videos) but didnt found out a solution.
Could you give me an example. Lets say we have 3 list saved as file and we need to put them in a table.
items of list one in column A,
items of list 2 in column B,
items of list 3 in column C.
Regards

 

[rostonix]

Create a loop:

1) take first line from list 1 and put to variable Var1
2) take first line from list 2 and put to variable Var2
3) take first line from list 3 and put to variable Var3
4) table processing - add line and put:
{-Variabe.Var1-};{-Variabe.Var2-};{-Variabe.Var3-}

In table settings you set ; as separator

And to all again in loop while you have lines in lists)

 

[bluenotes]

Allmost fine !
The only thing is that i get all variables ({-Variabe.Var1-},{-Variabe.Var2-},{-Variabe.Var3-}) in one column A, then same process in column B, C... and so on.
I set ; as column separator and have new line as line separator.
And i would like all var 1 in col A, var 2 in col B, var 3 in col 3.
WHere is the mistake?:huh:

 

[rostonix]

You have to set separator in Excel too after you open your final file.

 

[bluenotes]

Merci beaucoup ! for your help :rolleyes: