In a Pick-style dictionary, a correlative like this should work: T1,4^253TOTHER.FILE;X;;99 or: A1(T1,4)(TOTHER.FILE;X;;99) or: F;1;(T1,4);(TOTHER.FILE;X;;99)
or as an I-descriptor expression: TRANS(OTHER.FILE,SUBSTRINGS(F1,1,4),99,'X') Best Regards, Richard Lewis IBM Certified Solutions Expert --- On Mon 05/19, Brenda Price < [EMAIL PROTECTED] > wrote: From: Brenda Price [mailto: [EMAIL PROTECTED] To: [email protected] Date: Mon, 19 May 2008 15:23:59 -0500 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 thefirst 4 digits of those ids, then read another field with each of thoseextracted ids. My dict item works fine until I add the [1,4], then onlythe first 4 digits of the first 10 digit Id is returned. My co-workerwith 25 years plus experience is drawing a blank on this at the momentalso.Rec<1> = 1154960101:@vm:3456960201:@vm:4565982341Dict item comes back with 1154 only, instead of 1154, 3456, and 4565.Brenda PriceAAC-------u2-users mailing [EMAIL PROTECTED] unsubscribe please visit http://listserver.u2ug.org/ _______________________________________________ No banners. No pop-ups. No kidding. Make My Way your home on the Web - http://www.myway.com ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
