@mscislawin said in Regular replace does not work with multiple single quotes:
when i copy that and paste it to n++ and do the normal find plus normal replace and want to replace all ‘’ with ’ it only replaces first occurence of the ‘’
Did you click Replace or did you click Replace All after setting up Find what: '' and Replace With: ' ?
Because
76b51f95-e538-48cd-9e09-46b913b4812e-image.png
=>
f7fde8af-b620-4656-b355-c851309e7048-image.png
'insert into db.table(parent_id, active, code, name) values (1, true, ''code'',''name'');'
'insert into db.table(parent_id, active, code, name) values (1, true, ''code'',''name'');'
'insert into db.table(parent_id, active, code, name) values (1, true, ''code'',''name'');'
'insert into db.table(parent_id, active, code, name) values (1, true, ''code'',''name'');'
'insert into db.table(parent_id, active, code, name) values (1, true, ''code'',''name'');'
=>
'insert into db.table(parent_id, active, code, name) values (1, true, 'code','name');'
'insert into db.table(parent_id, active, code, name) values (1, true, 'code','name');'
'insert into db.table(parent_id, active, code, name) values (1, true, 'code','name');'
'insert into db.table(parent_id, active, code, name) values (1, true, 'code','name');'
'insert into db.table(parent_id, active, code, name) values (1, true, 'code','name');'
It does exactly what I’d expect