formatting data

[Robert Mann]

Thanks John
how do I now get this info into new fld
in this format
6  25
4  26
3  22


Robert Mann
President
GP Racing LLC

-----Original Message-----
From: use-revolution-bounces at lists.runrev.com
[mailto:use-revolution-bounces at lists.runrev.com]On Behalf Of John Craig
Sent: Wednesday, November 01, 2006 5:42 PM
To: How to use Revolution
Subject: Re: formatting data


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
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>

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