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 <jthompson...@gmail.com>wrote:

> Thank you for your help!
>
>
> On Mon, Sep 12, 2011 at 4:39 PM, John Thompson <jthompson...@gmail.com>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 <wjhon...@aol.com> 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 <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
>>>
>>
>>
>>
>> --
>> John Thompson
>>
>
>
>
> --
> John Thompson
>



-- 
John Thompson
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to