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 <[email protected]> To: U2 Users List <[email protected]> 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 <[email protected]> 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 [email protected] 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: [email protected] [mailto: [email protected]] 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 <[email protected] >wrote: > What happens if you do: > > TRANS('PRODUCT',PRD.ID.90,'12','V') ; @1<1,1> > Mr2 > Cost > 10R > S > > > > -----Original Message----- > From: [email protected] [mailto: > [email protected]] 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 > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > -- John Thompson _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users -- ohn Thompson ______________________________________________ 2-Users mailing list [email protected] ttp://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
