RE: [U2] Help in creating Retrieve statement for a multivalue field
You can use an EVAL or an i-descriptor. For example, assuming your field is the ID, then EVAL @ID[2] will give you the year, and EVAL FIELD(@ID, '*', 4, 1) will give you the route. (or you could use field(5) for the year :-) Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 June 2007 10:42 To: [EMAIL PROTECTED] Subject: [U2] Help in creating Retrieve statement for a multivalue field Thank you all for the help. BY-EXP did the work. I need another help to sort the data by one or multiple characters in a field. 01*GAN100*GAN100*WS09*07-In this filed how do I query the last two characters like 07 (year) or WS09 (Route)? Thanks again. Krish --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Help in creating Retrieve statement for a multivalue field
You want BY-EXP not BY -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, June 05, 2007 1:42 PM To: u2-users@listserver.u2ug.org Subject: [U2] Help in creating Retrieve statement for a multivalue field My retrieve statement produced below is not formatting properly. I want the first column to be repeated for each period. SORT SACM.AOS.P BY FDX.Period FDX.Period FMT 30L @ID FMT 35L FDX.NumOfDel LPTR SACM.AOS.P Period ##. SACM.AOS.P. Num Of Del 06 4 01*GAN100* 01 01*GAN100*GAN100*WS09*07 1 GAN100*WS0 9*07 02 1 03 4 04 4 05 2 06 Thanks Krish --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Help in creating Retrieve statement for a multivalue field
[EMAIL PROTECTED] wrote: My retrieve statement produced below is not formatting properly. I want the first column to be repeated for each period. SORT SACM.AOS.P BY FDX.Period FDX.Period FMT 30L @ID FMT 35L FDX.NumOfDel LPTR SACM.AOS.P Period ##. SACM.AOS.P. Num Of Del 06 4 01*GAN100* 01 01*GAN100*GAN100*WS09*071 GAN100*WS0 9*07 02 1 03 4 04 4 05 2 06 Look up BY.EXPLD -- Allen Egerton aegerton at pobox dot com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/