正则表达式
比如有这种数据
{"@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"}
要是想弄期待值 正则得怎么写??
正则表达式
比如有这种数据
{"@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"}
要是想弄期待值 正则得怎么写??
'"@.+?,' 替换成 空
数据库测试
SELECT dbo.MyReplace('{"@timestamp":"2022-06-24T03:15:01.258Z","id":1,"name":"test123","@version":"1","age":30},{"a":"a1"}','"@.+?,','')
网页测试