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
_______________________________________________
U2-Users mailing list
[email protected]
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to