Speed is not an issue. Doing it by hand would kill someone.
Thanks for pointing out the "substr of". I was only using a single substr and using OF to separate the rest of the stuff. It is working now and I am quite happy with what I learned today. Have a great weekend. ____________________ Jim Hughes 603-271-5586 "It is fun to do the impossible." ==>-----Original Message----- ==>From: CMSTSO Pipelines Discussion List [mailto:CMS- ==>[email protected]] On Behalf Of Bob Cronin ==>Sent: Friday, July 31, 2009 4:52 PM ==>To: [email protected] ==>Subject: Re: XLATE a string ==> ==>Alrighty then, how about this? ==> ==>'PIPE Strliteral /15 crcs001-REG-WORKER-ID$PIC X(00023)./', ==> '| Xlate Substr 2-* of', ==> ' Substr Fs - F2 of', ==> ' Substr W2 of', ==> ' Substr Fs $ F1 of 1-* Lower', ==> '| Console' ==> ==>All the other solutions posted look like they will work as well, but I ==>believe my formulation follows your original specification the ==>closest. It truly will only work on chars 2-* of the second field ==>delimited by dash of the second word of the first field delimited by $ ==>(i.e. the specs read almost literally like what you asked for). On the ==>other hand it may be horribly inefficient :-) ==> ==>bc
