At 18:01 24/09/2014 +0100, Tom Davies wrote:
On 24 September 2014 17:47, Tom Davies wrote:
We had a question a bit like this a few weeks ago and had some
great answers. Can anyone remember any of the command-line or
text-editor approaches?
Errr, the context is that there is a list of local councillor's
contact details on a website and i kinda need to extract their email
addresses. There's about 42 of them and the listing on the website
is a bit like this (ie a bit variable)
[Various lines of text]
[email protected]
[More text]
[email protected]
You could probably delete everything except forty-two one-line
paragraphs more quickly that writing this message, but possibly not reliably.
o Search for .+@.+ and replace by &# with "Regular expressions" ticked.
o Click Replace All.
o Now click Find All.
o Go to Edit | Copy (or Ctrl+C).
o In a new document (or wherever), go to Edit | Paste (or Ctrl+V).
o In the new text, search for # and replace with \n (or \t or comma
or space or whatever).
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
