You could have to replace several “whatever”, f.e. in a sql file I had to replace many columns with dates, such as ‘2005-08-15’ splitting them in ‘2005’, ’08’, ’15’. <\/p>\n\n\n\n
I manage to do it with this code: <\/p>\n\n\n\n
find NULL, '(.*?)-(.*?)-(.*?)', NULL, NULL, NULL\nreplace NULL, '\\1', '\\2', '\\3', NULL<\/pre>\n\n\n\nIn this way you can replace
'2005-08-15', NULL, NULL, NULL<\/code> with'2005', '08', '15', NULL<\/code>, and likewise all the like, such as'2012-06-23', NULL, NULL, NULL<\/code> with'2012', '06', '23', NULL<\/code> and so on.<\/p>\n\n\n\nBut, be careful: make a backup of your file before.<\/p>\n\n\n\n
another case: if you want replace several digits with the same digits formatted, you can try something like this code:<\/p>\n\n\n\n
search: ^ (\\d{2})$\nreplace: <h2>cap. \\1<\/code><\/h2>\\n<\/pre>\n","protected":false},"excerpt":{"rendered":"You could have to replace several “whatever”, f.e. in a sql file I had to replace many columns with dates, such as ‘2005-08-15’ splitting them in ‘2005’, ’08’, ’15’. I manage to do it with this code: find NULL, ‘(.*?)-(.*?)-(.*?)’, NULL, NULL, NULL replace NULL, ‘\\1’, ‘\\2’, ‘\\3’, NULL In this way you can replace … <\/p>\n