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 trickspick 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 < 99
Rob, 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
