when you group searches in the textpad regex editor you have to escape the grouping brackets with a backslash otherwise it searches them as literal characters for example: \([0-9]\) will search for any number 0-9 but if you omit the the escape slash it will look for (1) for example...

replacing two chars using an or (pipes) String p = "text to search.. through with = and , and ^regex"; System.out.println("result: "+ p.replaceAll(",|=", "") ); if you want to strip all the tags out you can use: System.out.println("p: "+ p.replaceAll("\\W", " ") ); note.. that will strip spaces...

As a point of reference how to convert a comma delimited file to an SQL insert Assuming your data is the following 'key','value','0' 'key','value','1' In notepad++ the syntax for search and replace would be as follows: search: ('[^']+','[^']+','[^']+') replace: (\1) syntax varies d...