Re: [libreoffice-users] Regular expressions

2021-07-09 Thread Remy Gauthier
Hello, Regular expressions are a shorthand way of specifying strings against which to match an input. In the COUNTIF(), MATCH(), VLOOKUP(), etc. functions, when you provide a regular expression, you are asking to compare your input to a summary version of what you are looking for. For example, the

Re: [libreoffice-users] Regular expressions

2021-07-09 Thread Dave Howorth
On Thu, 8 Jul 2021 22:38:49 +0100 David Lynch wrote: > The documentation > > for COUNTIF gives the following examples, among others: > > =COUNTIF(A1:A10;">=2006") > =COUNTIF(A1:A10;"<") > =COUNTIF(A1:A10;C2) > =COUNTIF(A1:A10;"<0") >  and these do indeed work. > >  However the list of

Re: [libreoffice-users] Regular Expressions

2019-05-09 Thread Keith Bates
Thank you, Brian. That was exactly what I needed Keith On 10/5/19 1:46 pm, Brian Barker wrote: At 11:13 10/05/2019 +1000, Keith Bates wrote: I have a text document that contains various mark up tags such as . It's a list of song lyrics from OpenLP. I want to strip off all the tags- the <,>

Re: [libreoffice-users] Regular Expressions

2019-05-09 Thread Brian Barker
At 11:13 10/05/2019 +1000, Keith Bates wrote: I have a text document that contains various mark up tags such as . It's a list of song lyrics from OpenLP. I want to strip off all the tags- the <,> and the text between. I know search and replace with Regular Expressions will do it for me, but I

Re: [libreoffice-users] Regular expressions

2011-06-27 Thread Simon Cropper (The foss Workflow Guides)
On 28/06/11 00:06, Séamas Ó Brógáin wrote: I wonder if some regex wizard knows of a way to delete HTML (or XML or whatever) tags from a text file: in other words, selecting everything from each occurrence of to the next occurrence of. If you are trying to do this from within LibreOffice use

Re: [libreoffice-users] Regular expressions

2011-06-27 Thread Séamas Ó Brógáin
Thanks for that tip, Simon. Unfortunately that site seems to have gone missing. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more:

Re: [libreoffice-users] Regular expressions

2011-06-27 Thread Séamas Ó Brógáin
Gene wrote: A Google search will find a download site. It does work well. I did a web search, but all the references pointed to the same site, which does not work. -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to

Re: [libreoffice-users] Regular expressions

2011-06-27 Thread Gene Young
On 6/27/2011 4:16 PM, Séamas Ó Brógáin wrote: Gene wrote: A Google search will find a download site. It does work well. I did a web search, but all the references pointed to the same site, which does not work. a search for Alternative Find and Replace download gave this as the 4th

Re: [libreoffice-users] Regular expressions

2011-06-27 Thread Brian Barker
At 15:06 27/06/2011 +0100, Séamas Ó Brógáin wrote: I wonder if some regex wizard knows of a way to delete HTML (or XML or whatever) tags from a text file: in other words, selecting everything from each occurrence of to the next occurrence of . I'm not sure I qualify as a wizard, but I'll

Re: [libreoffice-users] Regular expressions

2011-06-27 Thread Séamas Ó Brógáin
Thank you very much, Brian. I’ll try that also. (I think your wizardry has already been established.) -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org Posting guidelines + more:

Re: [libreoffice-users] regular expressions

2011-03-11 Thread MR ZenWiz
On Thu, Mar 10, 2011 at 11:42 PM, Peter G. Underwood pgunderw...@wol.co.za wrote: How can I switch this list to a daily digest format, please? -- Please read what it says below and get help from the same email address as unsubscribe. -- Unsubscribe instructions: E-mail to

Re: [libreoffice-users] regular expressions

2011-03-10 Thread Peter G. Underwood
How can I switch this list to a daily digest format, please? -- Peter G. Underwood tel/fax: +27 21 761 8463 4 Brentwood Close cell:+27 84 650 3091 11C Indian RoadSkype:

Re: [libreoffice-users] regular expressions

2011-03-07 Thread Karl-Heinz Bellgardt
Hi, even in a mailing list it would be polite to see a kind of salutation and your real name. On 07.03.2011 12:17, gymka wrote: how in libreoffice writer replace text: /22./ to /022./ ??? regular expressions not working(or i don't know how to use them) in replace input. eg. i write find:

Re: [libreoffice-users] regular expressions

2011-03-07 Thread gymka
imho if i want answer to my question i need to write as short as possible and give as much information as possible. if you want: hello people, i'm Algimantas. i'm live in east europe. as i said imho it's uncessary offtopic and with this message i'm just wasting other peoples time and internet

Re: [libreoffice-users] regular expressions

2011-03-07 Thread Lorenzo Sutton
Dear Algimantas, gymka wrote: imho if i want answer to my question i need to write as short as possible and give as much information as possible. if you want: IMHO if you want an answer to my question it helps being kind and maintaining some 'social behaviour' as in any activity where

Re: [libreoffice-users] regular expressions

2011-03-07 Thread gymka
thank you. On 2011.03.07 14:51, Lorenzo Sutton wrote: Dear Algimantas, gymka wrote: imho if i want answer to my question i need to write as short as possible and give as much information as possible. if you want: IMHO if you want an answer to my question it helps being kind and maintaining

Re: [libreoffice-users] regular expressions

2011-03-07 Thread John Davies
Please take me off the mailing list or tell me how to.  TYVM  JAD From: Marc Grober m...@interak.com To: users@libreoffice.org users@libreoffice.org Sent: Mon, March 7, 2011 8:31:37 AM Subject: Re: [libreoffice-users] regular expressions If you want

Re: [libreoffice-users] regular expressions

2011-03-07 Thread Glenn
me how to. TYVM JAD From: Marc Grober m...@interak.com To: users@libreoffice.org users@libreoffice.org Sent: Mon, March 7, 2011 8:31:37 AM Subject: Re: [libreoffice-users] regular expressions If you want to replace any digit try /[:digit:]{2

Re: [libreoffice-users] regular expressions

2011-03-07 Thread MR ZenWiz
On Mon, Mar 7, 2011 at 6:41 AM, John Davies john7dav...@yahoo.com wrote: Please take me off the mailing list or tell me how to. TYVM  JAD Just read what it says below (or at the bottom of ALL emails to this list). -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive:

Re: [libreoffice-users] regular expressions

2011-03-07 Thread MR ZenWiz
On Mon, Mar 7, 2011 at 6:52 AM, Glenn glenns...@gmail.com wrote: Get yourself out of what you got yourself into! Now you want donators, etc. to help you undo what you unwittingly subscribed to. How many time have you done this to other user-supported sites? Grow up! Ouch! And they say