![]() If there are empty email addresses: ( ),(*), // assuming that the email is the second parameter first last, bob builder, foo.įirst the Notepad flavor of regexp, you don't need to escape groupings with backslashes, so the corresponding search regexp would be: ( ),( ), You may optionally modify the regexps to put a space after the commas if that is how the text file is formatted or how you want it formatted, e.g. Type this into the replace box: \1,\2\n.Type this into the search box: \( \),\( \),.But fear not! Regexps are here to help once more: If that's the case, then it's a little more difficult to do than just replacing all commas with line-breaks. If you open it up in Excel/Calc, it should now be a column of names/e-mails.Īctually, re-reading your question, it occurs to me that you may want 2 columns: 1 for email, one for name. ![]() ![]() Despite what the above checkbox reads, it's actually Regular expression search AND replace-meaning that you can use regexps in the Replace box as well.So check the box that says Regular expression search. That's OK because Notepad2 supports regex right out of the box. Now you'll notice that the Replace with: box is only a single-line.Type a comma or comma and space into the Search String box.Open up the text file and hit Ctrl H to bring up the find
0 Comments
Leave a Reply. |