here's a snippet that should work for 10 rows of fields - c1r1, c2r1, c1r2, c2r2, etc...

put 1 into writeRow
 repeat with i = 1 to 10
   put fld("c1r" & i) into value1
   put fld("c2r" & i) into value2
   if value1 <> empty or value2 <> empty then
     if i > writeRow then
       put value1 into fld("c1r" & writeRow)
       put value2 into fld("c2r" & writeRow)
       put empty into fld("c1r" & i)
       put empty into fld("c2r" & i)
     end if
     add 1 to writeRow
   end if
 end repeat


JC


Robert Mann wrote:
I have 2 columns of fields with many rows much like a excel speed sheet, I
have data in row one C1R1, C2R1(6, 25), no data in rows 2 and 3, data in row
4 C1R4, C2,R4(4, 26) data in row 5 C1R5, C2R5 (3, 22),
how would I format this data into one continuous column such as
6  25
4  26
3  22


Thanks
Robert Mann
President
GP Racing LLC

_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution

Reply via email to