Re: [libreoffice-users] Re: searching for a string containing a certain character and appending that string to a new file

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]
> cheerful.chap@unlikelycompany.co.uk
> [More text]
> whosename@wasememjig.com

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: users+unsubscribe@global.libreoffice.org
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