hi,
exist a function equivalent to SQL function substring?
good alternative would be:
1 3 sublist “test string”
“est”
check also
ss
ssr
cut
http://code.kx.com/wiki/Reference/sublist
You generally have to build these things yourself.
q)tab:( FirstName:(“foooo”;“john”);LastName:(“bar”;“Doe”))
q)
q)tab
FirstName LastName
“foooo” “bar”
“john” “Doe”
q)substr:{(y-1;z) sublist/:x}
q)
q)select LastName,new:substr[FirstName;2;6] from tab
LastName new
“bar” “oooo”
“Doe” “ohn”
q)
q)select LastName,new:substr[FirstName;1;2] from tab
LastName new
“bar” “fo”
“Doe” “jo”
“Cut” could also acheive this