The data looks like so in the PRODUCT file... 012: 1400²²²²1391
Those are value marks. I guess I should have entitled this... I-Type TRANS Multivalue question... On Mon, Sep 12, 2011 at 4:39 PM, John Thompson <[email protected]>wrote: > Thank you for your help! > > > On Mon, Sep 12, 2011 at 4:39 PM, John Thompson <[email protected]>wrote: > >> The @1<1,1,1> worked. >> >> Weird... So the output is not the same as whats in the data? >> >> Be nice of them to document that :) >> >> >> On Mon, Sep 12, 2011 at 4:37 PM, Wjhonson <[email protected]> wrote: >> >>> >>> 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 >>> >> >> >> >> -- >> John Thompson >> > > > > -- > John Thompson > -- John Thompson _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
