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

Hi :)
Perfect!!  Thanks :)))

It's not quite what i asked for but did get exactly the result i wanted and
it was nice to use LibreOffice to do it.
Fantastic!  Thanks Brian!
Many regards from
Tom :)



On 24 September 2014 18:53, Brian Barker <b.m.barker@btinternet.com> wrote:

> 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

-- 
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