how extract numbers particular column composed of strings eg:
(`category:"abc 124m def 154m" ; "hij 120m hij 174m" ; "stu 126m def 166m" ; "abx 67m def 66m" )
answer:
124,154
120,174
126,166
67,66
there might more efficient answers out there, works:
q)f:{except[;0nj]"j"$" "vs?[x in "0123456789";x;" "]} q)category "abc 124m def 154m" "hij 120m hij 174m" "stu 126m def 166m" "abx 67m def 66m" q)f each category 124 154 120 174 126 166 67 66 
Comments
Post a Comment