formatting data

[John Craig]

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
>
>