Not for nothin' but could you give me some examples. I don't get the ICONV part of this. Thanks. ----- Original Message ----- From: "Barry Rogen" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, October 18, 2005 9:46 AM Subject: RE: [U2] Translate question
> OCONV(ID,"TFILE;X;15;15") > > or > > OCONV(ID,"TFILE;Xvloc;iloc;oloc) > > > vloc Number of the value to be returned from a > multivalued field. If you do not specify vloc and > the field is multivalued, the whole field is > returned with all system delimiters turned into > blanks. If the vloc specification follows the oloc > or bloc specification, enclose vloc in square > brackets or separate vloc from oloc or bloc with a > comma. > > iloc Field number (decimal) for input conversion. The > input value is used as a record ID in the lookup > file, and the translated value is retrieved from > the field specified by the iloc. If the iloc is > omitted, no input translation takes place. > > oloc Field number (decimal) for output translation. > When RetrieVe creates a listing, data from the > field specified by oloc in the lookup file are > listed instead of the original value. > > Cheers, > > Barry Rogen > PNY Technologies, Inc. > Senior Programmer/Analyst > (973) 515 - 9700 ext 5327 > [EMAIL PROTECTED] > > ----------------------------------------------------- > Far better it is to dare mighty things, to win > glorious triumphs even though checkered by > failure, than to rank with those poor spirits who > neither enjoy nor suffer much because they live > in the gray twilight that knows neither victory > nor defeat > ---------------------------------------------------------------- > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson > Sent: Tuesday, October 18, 2005 8:51 AM > To: [email protected] > Subject: Re: [U2] Translate question > > I don't get it. If I'm retrieving the 15th attribute from FILE, ID, what > is > being ICONV'd? Is there a WRITE possibility? > Thanks. > > ----- Original Message ----- > From: "Bruce Nichol" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Tuesday, October 18, 2005 12:15 AM > Subject: Re: [U2] Translate question > > > > Goo'day, Mark,At 23:16 17/10/05 -0400, you wrote: > > > > >I've always used the OCONV(ID,"TFILE;X;15;15") form for translates. > What > is > > >the difference between the first and second '15's. I've seen "X;;15" > work > and > > >"X;15" not work. > > > > The difference is in "ICONV" vs "OCONV" .... > > > > The first "15" is for ICONV's and the second "15" is for OCONV's > > > > AFAIK, "standard" over all implementations... > > > > HTH > > > > >Thanks in advance. > > >Mark Johnson > > >------- > > >u2-users mailing list > > >[email protected] > > >To unsubscribe please visit http://listserver.u2ug.org/ > > > > > > > > >-- > > >No virus found in this incoming message. > > >Checked by AVG Anti-Virus. > > >Version: 7.0.344 / Virus Database: 267.12.2/138 - Release Date: > 17/10/05 > > > > > > > > > > > > > > >-- > > >No virus found in this incoming message. > > >Checked by AVG Anti-Virus. > > >Version: 7.0.344 / Virus Database: 267.12.2/138 - Release Date: > 17/10/05 > > > > Regards, > > > > Bruce Nichol > > Talon Computer Services > > ALBURY NSW 2640 > > Australia > > > > http://www.taloncs.com.au > > > > Tel: +61 (0)411149636 > > Fax: +61 (0)260232119 > > > > If it ain't broke, fix it till it is! > > > > > > -- > > No virus found in this outgoing message. > > Checked by AVG Anti-Virus. > > Version: 7.0.344 / Virus Database: 267.12.2/138 - Release Date: > 17/10/05 > > ------- > > u2-users mailing list > > [email protected] > > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
