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
