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

2011-07-01 Thread Stephan Zietsman
Ryan Jendoubi wrote: This is set up pretty much how I'd like it to work (without the looong list of input on the first sheet). I wasted half my day Googling this and trying various things, and the IRC channel has declared it impossible without a macro. If you've thought of a winning formula

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

2011-07-01 Thread Ryan Jendoubi
Hi Stephan, On 01/07/11 10:00, Stephan Zietsman wrote: I've had a look at the spreadsheet, and tried a few formulas. It seems that to do this with formulas is quite tricky and unfortunately I couldn't get it done. I tried a few different approaches and I think it is technically possible.

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

2011-07-01 Thread Tom Davies
@global.libreoffice.org Cc: Ryan Jendoubi ryan.jendo...@gmail.com Sent: Fri, 1 July, 2011 10:28:37 Subject: Re: [libreoffice-users] Match cell against any of range of regexes? Hi Stephan, On 01/07/11 10:00, Stephan Zietsman wrote: I've had a look at the spreadsheet, and tried a few formulas. It seems

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

2011-07-01 Thread Stephan Zietsman
Ryan Jendoubi wrote: LO macros would definitely be a good skill to learn eventually, even if it's not at the top of my todo list at the moment. I haven't yet searched for any tutorials or the like, but I'd be interested to hear if you have any personal favourites which you think would suit

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

2011-06-30 Thread Ryan Jendoubi
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

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

2011-06-30 Thread Stephan Zietsman
Ryan Jendoubi wrote: 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

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

2011-06-30 Thread Ryan Jendoubi
Hi Stephan, On 30/06/11 15:22, Stephan Zietsman wrote: could you possibly upload a sample file to look at? I have a possible idea of what to do, but I think the best way for me to check would be by using an example. Thank you very much for the offer (and the upload site tip).

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

2011-06-30 Thread jorge
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

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

2011-06-30 Thread jorge
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

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

2011-06-30 Thread Ryan Jendoubi
Hi Jorge, On 30/06/11 17:16, jorge wrote: El jue, 30-06-2011 a las 10:09 -0600, jorge escribió: 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: [...] Thanks for your explanation. I get what you were saying, but what I'm