Re: [libreoffice-users] Match cell against any of range of regexes?

Hi again:

The e-mail made a change. The final Result is like this:

Search Engine           Information
Google                  CNN
Bin                     Hotmail
Mamma                   Sports

Regards,

Jorge Rodríguez

_________________
> El jue, 30-06-2011 a las 10:09 -0600, jorge escribió:
> > Hi:
> >
> > I would suggest to do as this (If you have order the information as you
> > explain and show in your e-mail):
> >
> > 1) Sheet 1:
> >
> >     a) Put "1" (without "") in each search engine but in column B
> >     b) Put "2" (without "") in each information relative to search engine
> > in column B too.
> >
> > Something like this:
> >
> >
> > > Data
> > > Clasification
> > > google
> > >                                   1
> > > cnn
> > >                                   2
> > > bin
> > >                                   1
> > > hotmail
> > >                                   2
> > > Sport
> > >                                   2
> > > mamma
> > >                                   1
> >
> >     c) Use Automatic Filter (Data Menu) and select all "1" Clasification.
> > Copy and paste in Sheet 2 in column A. Like This:
> >
> >
> > > Search Engine
> > > google
> > > bin
> > > mamma
> >
> >     d) Do the same process for "2" and the result copy and paste in Sheet 2
> > in column B and the final result it could be like this:
> >
> >
> > > Search Engine
> > > Information
> > > google
> > > cnn
> > > bin
> > > hotmail
> > > mamma
> > > Sport
> >
> >
> > I hope you understand me and solve your problem.
> >
> > Regards,
> >
> > Jorge Rodríguez
> >
> > _____________________
> >  
> >
> >
> >
> >
> > El jue, 30-06-2011 a las 14:22 +0100, Ryan Jendoubi escribió:
> > > Hi all,
> > >
> > > Is the operation in the subject line possible?
> > >
> > > More info (maybe I'm asking the wrong question):
> > >
> > > I have a (long) list of URLs, and want to categorise them. The 
> > > categories themselves could be pretty broad: news sites, search engines, 
> > > music sites, etc. Similar URLs (different pages on the same site) come 
> > > up many times. So what I'd like to do is define regexes to say "If the 
> > > URL has 'guardian.co.uk' in it, make it a 'News' site".
> > >
> > > Sheet 1 (list to process; I want to insert the categorising function in 
> > > col B)
> > > ====
> > > A | B
> > > ----
> > > google.com
> > > cnn.com/foo
> > > guardian.co.uk/foo
> > > duckduckgo.com
> > > cnn.com/bar/baz
> > > bing.com
> > >
> > > Sheet 2 (columns of site name regexes; col A is news sites, B is search 
> > > engines, etc)
> > > ====
> > > A | B
> > > ----
> > > cnn | google
> > > guardian | duckduckgo
> > >   | bing
> > >
> > > The SEARCH function doesn't seem to take a range or array as its findtext.
> > >
> > > Any ideas on how to go about this?
> > >
> > > Many thanks!
> > >
> > > --Ryan

-- 
Atentamente,

Jorge Rodríguez


-- 
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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