Home › Forums › kdb+ › Something for the weekend? › Re: Something for the weekend?
-
Masking is nice but as an alternative & still taking care not to remove leading blanks
q){x where 1b,1_not” “~’:x}s:” the quick brown fox ” ” the quick brown fox ”
Appears to be faster
q)S:10000000#s q)ts:5 {x where not n&prev n:null x}S 197 100663904 q)ts:5 {x where 1b,1_not" "~':x}S 147 83886816
caching taking place?
q)ts:5 {x where not n&prev n:null x}S 144 100663904 q)ts:5 {x where 1b,1_not" "~':x}S 148 83886816