关于数据处理正则表达式

Question

正则表达式
比如有这种数据
{"@timestamp":"2022-06-24T03:15:01.258Z","id":1,"name":"test123","@version":"1","age":30},{"a":"a1"}
我想把上数据利用正则每包含@的数据删掉。
期待值的数据为 {"id":1,"name":"test123","age":30},{"a":"a1"}

要是想弄期待值 正则得怎么写？？

Answer 1

'"@.+?,' 替换成 空
数据库测试
SELECT dbo.MyReplace('{"@timestamp":"2022-06-24T03:15:01.258Z","id":1,"name":"test123","@version":"1","age":30},{"a":"a1"}','"@.+?,','')

网页测试