Hi, Jack. Both pick stages in the example use the string ">>==" and "<<==" comparison operators so the fields are compared as text values and not as numberic ones.
An example; geven the file TIME DATA A type time data a 08:00 08:15 09:00 09:30 10:00 10:45 11:00 12:00 13:00 14:00 14:30 15:00 16:00 16:45 15:00 and the pipe: pipe < time data a | pick 1.5 >>= /09:00/| pick 1.5 <<= /16:59/|console The output will be: 09:00 09:30 10:00 10:45 11:00 12:00 13:00 14:00 14:30 15:00 16:00 16:45 15:00 Ready; T=0.01/0.03 15:51:09 Make sense? DJ On 02/25/2016 02:30 PM, Jack Woehr wrote:
Rob van der Heij wrote:Indeed as Kris says, PICK can compare fields by numeric value (using < and > rather the << and >> that are for string comparison). And be aware of the tricks pick w1 < ,99, When the first word is less than 99 pick w1 << ,99, String comparison, so "100" is less than "99" pick w1 < 99 Numeric value is less than what's in column 99 pick from w1 < ,99, All records after the first with w1 < 99Rob, Kris, thanks for replying. The IBM docs don't mention these < > operators, they just have << >> <<= >>= etc. They give this example: pipe < timestmp data | pick 45.5 >>= /09:00/| pick 45.5 <<= /16:59/|console So .. ??? -- Jack Woehr # "There's too much emphasis on things Box 51, Golden CO 80402 # like pawn structure in modern chess. http://www.softwoehr.com # Checkmate ends the game." - N. Short
-- Dave Jones V/Soft Software www.vsoft-software.com Houston, TX 281.578.7544
