SUBSTR is what I was missing.
Thanks Kris, /Fran --------------------------------------------------------------------- On Tue, 12 Feb 2008 14:14:43 +0200 Kris Buelens said: >For extra fields: just add () around the inputrange: > XLATE (FS , SUBSTR 1 OF F2 SUBSTR 1 OF F3 SUBSTR 1 OF F4) upper > >2008/2/12, Kris Buelens <[EMAIL PROTECTED]>: >> For one field: >> PIPE ... |XLATE FS , SUBSTR 1 OF F2 upper| ... >> >> 2008/2/12, Fran Hensler <[EMAIL PROTECTED]>: >> > I have a comma delimited file like this: >> > >> > kla7989,adair,kendra,l. >> > cxa1069,adams,christopher, >> > sla6045,addington,stephanie,l >> > ela7096,adkins,erika,l. >> > jaa7114,adragna,jacklyn,ann >> > jsa7489,aiken,julie,susan >> > maa5978,alcott,megan,a >> > >> > I'm trying to write a PIPE XLATE to translate the first byte of >> > fields 2, 3 and 4 to upper case. Seems like a simple task but I >> > can't get it. Does anyone want to give me some pointers? >> > >> > /Fran Hensler at Slippery Rock University of Pennsylvania USA for 44 years >> > [EMAIL PROTECTED] +1.724.738.2153 >> > "Yes, Virginia, there is a Slippery Rock" >> > > >-- >Kris Buelens, >IBM Belgium, VM customer support
