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