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