我尝试在notepad++中使用正则表达式捕获和替换字符串,但结果并不如预期。数据库的格式如下:
(602, '0602', '[{"id":"9","value":""},{"id":"1","value":"1"}]'),
(1644, '0164', '[{"id":"9","value":""},{"id":"1","value":"3"}]'),
(1311, '0131', '[{"id":"9","value":""},{"id":"1","value":"100"}]'),
(1321, '0132', '[{"id":"9","value":""},{"id":"1","value":"150"}]')
任务是捕获并放置第二列(值为0602、0164、0131、0131),并将其作为id 9的值插入。例如,最终结果必须如下所示:
(602, '0602', '[{"id":"9","value":"0602"},{"id":"1","value":"1"}]'),
(1644, '0164', '[{"id":"9","value":"0164"},{"id":"1","value":"3"}]'),
(1311, '0131', '[{"id":"9","value":"0131"},{"id":"1","value":"100"}]'),
(1321, '0132', '[{"id":"9","value":"0132"},{"id":"1","value":"150"}]')
我尝试在Notepad++中使用这个正则表达式进行搜索:
(, '.*)("id":"9","value":"")
替换:
($1)("id":"9","value":"$1")
结果很接近,但不是我需要的。如果您知道正确的答案,请帮助我。谢谢您提前。