On Thu, Aug 18, 2011 at 1:17 PM, Colin Allinson <[email protected]> wrote: > I have a process that is continually scanning large logs so whatever I do > has to be very efficient (preferably built in stages). > > I want to select all records into the primary output stream where columns > 82-86 are a valid (leading zero) whole number. I also have to select on > columns 78-81 being one of 3 values - but this would be easy in a separate > stage.
How about verify 82-86 /0123456789/ When you did not have leading 0's but blanks, things get a bit more complicated. In that case, look at the datatype() built-in function in specs. | Rob
