formatting data

[Robert Mann]

Jim
what I have is a to columns of fields with many rows
fld c1r1 would have 6 in it
fld c2r1 would have 25 in it
fld c1r2 and c2r2 would have nothing in them
fld c1r3 and c2r3 would have nothing in them
fld c1r4 would have 4 in it
fld c2r4 would have 26 in it
fld c1r5 would have 3 in it
fld c2r5 would have 22 in it
so if you were looking at the fields you would see
6  25
empty flds
empty flds
4  26
3  22

what I would like to be able to do is put the data into a new fld
reformatted like this without the empty flds
6  25
4  26
3  22




Thanks



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 Jim Ault
Sent: Wednesday, November 01, 2006 6:20 PM
To: How to use Revolution
Subject: Re: formatting data



On 11/1/06 2:43 PM, "Robert Mann" <robmann at gp-racing.com> 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



> I have 2 columns of fields with many rows much like a excel speed sheet

Robert, does this mean one field contains
6, 25
,
,
4, 26
3, 22
--or ------------
6, 25


4, 26
3, 22

--or ------------
fld 1   fld 2
6             25


4             26
3             22

---------------- ???

If it is the first one then

filter field "excelData" without ",*"
filter field "excelData" without empty
replace comma with space in field "excelData"

If the second one then
filter field "excelData" without empty
replace space with empty in field "excelData"
replace comma with space in field "excelData"

Let me know if you are doing something different than 1 or 2

Jim Ault
Las Vegas


_______________________________________________
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