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+h...@global.libreoffice.org
In case of problems unsubscribing, write to postmas...@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
