Zugg Software :: View topic

Newbie Joined: 18 Dec 2003 Posts: 3

Greetings,

I am using triggers to capture values into a list, obtaining for example
this:

#VARIABLE list {|Name|Value1|Value2|%cr|James|assassin|321|%cr|Alexander|warrior|16}

which I display using #SAY %replace(@list,|," "), getting:

MASTER Joined: 28 Nov 2000 Posts: 4817 Location: USA

Add spaces to each entry to make them the length that you prefer.

Newbie Joined: 18 Dec 2003 Posts: 3

Thank you for the input.
The problem was that those names were captured with triggers
using (%w) wildcarts. So I couldn't set the length. But this
seems to fix it:

#MATH temporary (13-%len(@name))
#WHILE (@list <> 0) {#VAR name {%concat(@name," ")};#ADD temporary -1}

Seems to work fine.

GURU Joined: 26 Jul 2001 Posts: 1958 Location: Canada

Check out the %format() for when you add elements into the list perhaps.

Probably better to use record types (%db() %addkey() etc)

MASTER Joined: 28 Nov 2000 Posts: 4817 Location: USA

I'd use %1%repeat( " ", %eval( 13 - %len( %1))) with {} as delimiters. Faster than a loop.

I agree with Ton that a record-variable would be better than a list.

Newbie Joined: 18 Dec 2003 Posts: 3

Thanks, I'll look into those. I went with a list because I won't have
more than ten names at most each time, and am not too familiar with the DB,
but I'll try it out.

GURU Joined: 26 Jul 2001 Posts: 1958 Location: Canada

Here would be an idea; Someone more awake probably can drudge up something simpler Smile

:

#VAR dbtest ""

Keep a index/counter of how many groups we have stored:
#ADDKEY dbtest counter=1

Loop this when groupings are added:
#ADDKEY dbtest {Name_@dbtest.counter=Name|Value1_@dbtest.counter=Value1|Value2_@dbtest.counter=Value2}
#ADD dbtest.counter 1

Loop again:
#ADDKEY dbtest {Name_@dbtest.counter=James|Value1_@dbtest.counter=assassin|Value2_@dbtest.counter=321}
#ADD dbtest.counter 1

Loop again:
#ADDKEY dbtest {Name_@dbtest.counter=Alexander|Value1_@dbtest.counter=Warrior|Value2_@dbtest.counter=16}
#ADD dbtest.counter 1

To see the results with %expanddb:
#SH %expanddb(@dbtest,%crlf,":")

To see something with some semblance of columns:
#LOOP @dbtest.counter {#SH %format("&10s",%db(@dbtest,Name_%i)) %format("&10s",%db(@dbtest,Value1_%i)) %db(@dbtest,Value2_%i)}