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

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