Trans does not retain the marks as there are. Trans always LOWERs all marks. So to focus on any particular mark, you should next RAISE the entire output-so-far.
-----Original Message----- From: John Thompson <jthompson...@gmail.com> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Mon, Sep 12, 2011 1:26 pm Subject: Re: [U2] I-type Subvalue question No... I think you mean this? TRANS('PRODUCT', PRD.ID.90, '12', 'V'); @1<1.1> I also tried with 1,1 and no cigar... On Mon, Sep 12, 2011 at 4:24 PM, Caryl Lange <cla...@hme.com> wrote: > 1.1 instead? Avante 9.1.7a/SB+ on Windows, tasty GUI flavored Best Regards, Caryl Lange Applications Development Manager HME 14110 Stowe Drive Poway, California 92064 phone: (858) 646-8806 cla...@hme.com Visit our website: www.hme.com Please consider the environment before printing this email CONFIDENTIALITY NOTICE: E-mail may contain proprietary confidential information that is legally privileged. Do not read this e-mail if you are not the intended recipient. This e-mail transmission, and any documents, files or previous e-mail messages attached to it may contain proprietary information, trade secrets, and/or other confidential information that is legally privileged. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify the original sender by return E-mail, and destroy the original transmission and its attachments without reading or saving in any manner. Thank you. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, September 12, 2011 1:23 PM To: U2 Users List Subject: Re: [U2] I-type Subvalue question I get this still... DOR 610-434 0.78 0.00 0.00 0.00 0.53 That is a number 1 in the @1 right? On Mon, Sep 12, 2011 at 4:18 PM, George Gallen <ggal...@wyanokegroup.com >wrote: > What happens if you do: > > TRANS('PRODUCT',PRD.ID.90,'12','V') ; @1<1,1> > Mr2 > Cost > 10R > S > > > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org [mailto: > u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson > Sent: Monday, September 12, 2011 4:11 PM > To: U2 Users List > Subject: [U2] I-type Subvalue question > > Lets say I need to translate over to a file and get the cost of a product. > > However, the cost of the product is multivalued. > > How can I do this with an I-type and NOT grab all of the multi values? > > I > TRANS('PRODUCT', PRD.ID.90, '12', 'V') > MR2 > Cost > 10R > S > > So in attribute 12 of the PRODUCT file, I just need <12,1>. > > Do I need two I-types, or will TRANS() let me do this? > > The friendly manual seems to be failing me... > > -- > John Thompson > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- ohn Thompson ______________________________________________ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users