kdb - 在 kdb+ 中替换 " " 后删除 \n

Question

我有一个名为“t”的表，列为“x”。它看起来如下：

     `INPUT:"\n This is sample code"
     RESULT: "This is sample code"`

我想删除 \n 特定的表列值

标签： kdb

Answer 1

下面是一个示例，说明如何ssr在表格设置中实现所需的修剪：

q)t:([]a:1 2 3;b:("\nThis is sample code";"More good sample code";"\n More sample code"))
q)t
a b
-------------------------
1 "\nThis is sample code"
2 "More good sample code"
3 "\n More sample code"
q)@[t;`b;{trim ssr[x;"\n";""]}@']
a b
-------------------------
1 "This is sample code"
2 "More good sample code"
3 "More sample code"

希望这可以帮助。