Works great and if I'd put the 1,4 in the right place it would have worked earlier. Don't you just hate those days when you're doing something wrong and you know it but just can't think what it is. Especially when you've been doing this for 15 years, its downright embarrassing.
-----Original Message----- From: Brian Leach [mailto:[EMAIL PROTECTED] Sent: Monday, May 19, 2008 4:05 PM To: [email protected] Subject: RE: [U2] multi-valued extraction Hi Brenda The substring extraction does not vector in an I Descriptor. One way around it is to use OCONVS() OCONVS(@RECORD<1>,"T1,4") Brian > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price > Sent: 19 May 2008 21:24 > To: [email protected] > Subject: [U2] multi-valued extraction > > I know I've done this before several times in fact but for > some reason, today I just can't get my dict item to work correctly. > > > > Field 1 is multivalued with 10 digit ids, I want to extract > only the first 4 digits of those ids, then read another field > with each of those extracted ids. My dict item works fine > until I add the [1,4], then only the first 4 digits of the > first 10 digit Id is returned. My co-worker with 25 years > plus experience is drawing a blank on this at the moment also. > > > > Rec<1> = 1154960101:@vm:3456960201:@vm:4565982341 > > > > Dict item comes back with 1154 only, instead of 1154, 3456, and 4565. > > > > Brenda Price > > AAC > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
