Hi Brian, You need to set the CDELIM and RDELIM attributes to match the data your example is using " " (a space for a Delimiter) the default is CDELIM=, RDELIM=;
also you need a <@FOR> loop and use <@ADDROWS> to the array --code-- <@assign local$vSixColumns Value='<@ARRAY ROWS=<@NumRows> COLS=6 VALUE="@@MailArray[1,2],@@MailArray[1,3],@@MailArray[1,5],@@MailArray[1,6] @@MailArray[1,7],@@MailArray[1,8];">'> <@FOR START=1 STOP=<@NUMROWS ARRAY="MailArray"> <@ADDROWS ARRAY=vSixColumns VALUE="@@MailArray[<@CURROW>,2],@@MailArray[<@CURROW>,3],@@MailArray[<@CURRO W>,5],@@MailArray[<@CURROW>,6], @@MailArray[<@CURROW>,7],@@MailArray[<@CURROW>,8];"> </@FOR> --code-- ;-0 you might check for typos Ben Johansen - http://www.pcforge.com Authorized WiTango Reseller http://www.pcforge.com/WiTangoGoodies.htm latest beta downloads @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Brian Mowers Sent: Thursday, May 09, 2002 12:41 PM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Re: Making a 6 Column Array from a 13 column array. I can't seem to make this one work. I want to create a new 6 column array from a 13 column array in a results action. I also want to tack on a <@CRLF> at the end of the new array. Specifically I want columns 2,3,5,6,7,8 from the resultset array then I want to tack on an extra <@CRLF> at the end of it. Should be simple but this one is giving me fits. I don't splice and dice arrays, I usually work with <@column>,<@Col Num=n> etc. I have tried: <@assign local$vSixColumns Value='<@ARRAY ROWS=<@NumRows> COLS=6 VALUE="@@MailArray[*,2] @@MailArray[*,3] @@MailArray[*,5] @@MailArray[*,6] @@MailArray[*,7] @@MailArray[*,8]"> <@CRLF>'> But all I get is a one column array. Best regards, Brian Mowers ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
