There's just one problem with your attempt. You must remember that a
TRANS in UV will lower the delimiters. So if the field in the remote file
is value mark delimited, it will be sub-value mark delimited once TRANSed.
You're still an FNG it looks to me. (tic)
Gordon J. Glorfield
Sr. Applications Developer
MAMSI (A UnitedHealth Company)
301-360-8839
[EMAIL PROTECTED] wrote on 02/03/2006 04:54:51 PM:
> Finally a question I can answer. Oh boy I am not a newbie anymore.
> File1 dictionary item:
> Field(TRANS("FILE2",FIELD(@ID,'*',2),9,'X'),VM,3)
> so you TRANSLATE to FILE2 using the 2nd value in @ID to return the 9th
> element and then the 3rd position value.
[snip]
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
