Hello i would like to delete the end of each line after the second "," (coma) and write this : "'Allemagne');"
For example,
BEFORE :
AFTER :
I tried :
But it doesn't work...
May you help me ?
Thanks !
For example,
BEFORE :
Code: Select all
INSERT INTO zipcodes VALUES (01067,'Dresden','SN',13.7210676148814,51.0600336463379,1,1,'de');
INSERT INTO zipcodes VALUES (01069,'Dresden','SN',13.7389066401609,51.039558876083,1,1,'de');
INSERT INTO zipcodes VALUES (01097,'Dresden','SN',13.7439674110642,51.0667452412037,1,1,'de');
Code: Select all
INSERT INTO zipcodes VALUES (01067,'Dresden','Allemagne');
INSERT INTO zipcodes VALUES (01069,'Dresden','Allemagne');
INSERT INTO zipcodes VALUES (01097,'Dresden','Allemagne');
Code: Select all
ColumnModeOff
HexOff
UnixReOff
Find RegExp ","
Find RegExp ","
EndSelect
Key DEL
DeleteToStartofLine
"'Allemagne');"
May you help me ?
Thanks !