Another way to do the same thing would be to use the filter tag: <@Assign Local$SpacedArray <@ARRAY VALUE="A;B;C; ; ;D;E; ;F; ;G;H;">> Spaced Array Begins as = <@Var Local$SpacedArray><p> <@Assign local$SpacedArray <@filter array=local$SpacedArray expr="len(<@trim str='#1'>)">> Spaced Array now = <@Var Local$SpacedArray><p>
Dave Shelley -----Original Message----- From: Wolf, Gene [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 27, 2004 1:05 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: ARRAY?? Sure. Here's sample code. I've tested it, it works. <@Assign Local$SpacedArray <@ARRAY VALUE="A;B;C; ; ;D;E; ;F; ;G;H;">> Spaced Array Begins as = <@Var Local$SpacedArray><p> <@Assign Local$RowCount <@Numrows Array=Local$SpacedArray>> <@Assign Local$Ptr 1> <@FOR START="1" STOP="<@Var Local$RowCount>"> <@IFEMPTY VALUE="<@Trim Str=<@Var Local$SpacedArray[<@Currow>,1]>>"> <@ELSE> <@Assign Local$SpacedArray[<@Var Local$Ptr>,1] <@Var Local$SpacedArray[<@Currow>,1]>> <@IF EXPR="<@Currow>!=<@Var Local$Ptr>"> <@Assign Local$SpacedArray[<@Currow>,1] ' '> </@IF> <@Assign Local$Ptr <@Calc EXPR="<@Var Local$Ptr>+1">> </@IF> </@FOR> Spaced Array now = <@Var Local$SpacedArray><p> <@Assign Local$Ptr <@Calc EXPR="<@Var Local$Ptr>">> <@Comment>Delete Remaining blank rows in the Array</@Comment> <@FOR START="<@Var Local$Ptr>" STOP="<@Var Local$RowCount>"> <@Delrows Array=Local$SpacedArray> </@FOR> Spaced Array now = <@Var Local$SpacedArray><p> Hope this helps! -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 27, 2004 9:50 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: ARRAY?? Hey Gene, I have been trying to wrap my arms around this one. Do you have a simple example you could show/send me? For some reason the second loop never counts. Also, is it possible to do this using the <@for> tag? Thanks for any help. >May I suggest a solution? Introduce another variable called Ptr. >Initialize it to one. Walk through your loop testing each element >for values. For examining array fields for nulls I typically use ><@Trim Str="<@Var... > > Now, if you do NOT find the array element empty increment Ptr by >one. As long as the array elements have valid values Ptr will keep >pace with your look counter. When the first empty spot is detected >both counters will be the same. > > At the bottom of the loop you test to see the array element >pointed to by your loop index is empty. If not, test to see if loop >index and Ptr are the same. If so, do nothing. If not, assign the >element pointed at by your loop variable to the location pointed at >by Ptr and empty the element pointed at by your loop counter. Then >increment your loop counter and Ptr. When you run across an empty >cell, with your loop counter, you do not increment Ptr. > > This will collapse all of the empty space out of your array and >condense it at the end of your array. > > It is complicated to explain but very easy to do. A small loop >and a couple of if statements. > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >Sent: Wednesday, July 21, 2004 4:20 PM >To: [EMAIL PROTECTED] >Subject: Witango-Talk: ARRAY?? > > >Okay, > >I'm tired and crabby and need help. This should be simple, but for >some reason, I am just not seeing it. > >I have variables that I am populating with small amounts of text. >They are named ... > ><@VAR lcell1> = test1 ><@VAR lcell2> = ><@VAR lcell3> = test3 ><@VAR lcell4> = test4 >etc. >etc. >etc. > >Let's just stop at 4 for now to keep this simple (simple is good! Good simple) > >Now I created a loop and a counter that counts up to 4 and I have >added this in the loop... > ><@IFEMPTY <@VAR 'lcell<@VAR l_counter>'>> ><@ELSE> ><@ASSIGN NAME="llcell<@VAR l_counter>" VALUE="<@VAR 'lcell<@VAR l_counter>'>"> ></@IF> > >And when I display the results I can see the values correctly. It is >working as expected BUT I would like to skip the counter on every ><@VAR lcell that is empty. I other words, If <@VAR lcell2> is empty, >move the values from <@VAR lcell3> into <@VAR lcell2> and also move >the values from <@VAR lcell4> into <@VAR lcell3>. Is this making >sense? I would like to get all the variables named 1, 2, 3, 4 etc. >with no empty variables between. > >The final result should be a list of numbered variable that contain >no empty variables or empty variables in the end... > >Original Variables... > ><@VAR lcell1> = test1 ><@VAR lcell2> = ><@VAR lcell3> = test3 ><@VAR lcell4> = test4 > >Modified Variables > ><@VAR llcell1> = test1 ><@VAR llcell2> = test3 ><@VAR llcell3> = test4 ><@VAR llcell4> = > >Thanks > >There's gotta be an easy way to do this > >_______________________________________________________________________ _ >TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf >_______________________________________________________________________ _ >TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf