|
On Tue, 2002-02-05 at 15:10, Art Tostaine, Jr. wrote: > Carsten: > > Thanks, but I forgot to mention that this is V4R5. I don't see %Check there. > Hi Art I was going to post a response but Carsten beat me to it - much more elegant too. Mind you, we're still on V4R4 so lots of goodies missing there :) The way I'd tackle it is to create a pattern map that can be used for the separation. Use XLATE to get a result field where all numbers go to 9's and all alphas to A's. Then run a loop like Carsten's substringing out each byte from the XLATEed value and moving the matching byte from the original depending on it being A or 9. I've used this technique for extracting UK postcodes from addresses and it seems to work okay. Regards, Martin -- martin@dbg400.net jamaro@firstlinux.net http://www.dbg400.net /"\ DBG/400 - DataBase Generation utilities - AS/400 / iSeries Open \ / Source free test environment tools and others (file/spool/misc) X [this space for hire] ASCII Ribbon Campaign against HTML mail & news / \
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.