select with ssr function

Community Support
,
1

https://learninghub.kx.com/forums/topic/select-with-ssr-function

New to q and need some help.

I am trying to select a column and apply a function. This function would apply ssr to an existing column.


select {[x](ssr[x;".C";""])} orderID, cancelTime from t


Sample Table

orderID                cancelTime                   
----------------------------------------------------
"00193932455ORSL1.4.C" 2023.06.13D14:42:12.296856000
"00193935456ORSL1.1.C" 2023.06.13D13:56:47.006888000
"00193946420ORSL1.1.C" 2023.06.13D14:41:40.911418000
"00194008439ORSL1.5.C" 2023.06.13D17:14:06.267606000