It's a headcook, creating a table from two lists!

[theninjamanz 29]

round and round it's going and I can't work it out.

 

I have 2 lists.

 

here's one

 

a

b

c

d

e

f

g

 

 

here's the other

 

h

i

j

k

l

m

n

o

p

 

 

I want to create a text file that has the following (combines both the above in a CSV)

 

a,h

b,i

c,j

d,k

e,l

 

 

Can someone help me.

 

I am tring to add both these lists to a table in columns 0 and 1, but I just get one pasted after the other!

[keiooz 1]

What about the m-p list? Are you going to add it as well?http://imagicon.info/cat/5-34/vbulletin-eek.gif

[JohnB 255]

Try this:

 

clear list(%one)

clear list(%two)

clear list(%three)

set(#one, "a

b

c

d

e

f

g", "Global")

set(#two, "h

i

j

k

l

m

n", "Global")

add list to list(%one, $list from text(#one, $new line), "Delete", "Global")

add list to list(%two, $list from text(#two, $new line), "Delete", "Global")

set(#position, 0, "Global")

loop($list total(%one)) {

add item to list(%three, "{$list item(%one, #position)}, {$list item(%two, #position)}", "Delete", "Global")

increment(#position)

}

 

John

[theninjamanz 29]

Worked a treat Jon thanks.