Re: [libreoffice-users] regular expression in formula to investigate

On 08/25/2013 01:35 AM, Brian Barker wrote:
> At 23:26 24/08/2013 +0200, Pier Andreit wrote:
> > [...]
> > I cannot understand this part:
> > SEARCH("/[^/]*$", CELL("filename"))
> > I know it search in CELL("filename") but I cannot understand the
> > criteria "/[^/]*$" from the tests it seems to find the last "/" in any
> > string, and if you substitute the "/" with "." it works again finding
> > the last ".", it is very useful .... :-) :-) :-) :-)
> >
> > could somebody so marvellously noble and well-bred to explain the
> > regular expressions here used??
>
> I'm not even ordinarily noble - certainly not marvellously so - and I
> was only ordinarily bred; will I do?

...enough noble to be opensource knight...:-) :-)

> The first character in the text string is the slash that you are looking
> for.  A string in square brackets matches any single character which
> appears in that string.  But if the first character is a circumflex (as
> here), it matches any single character *not* in that string.  So
> leftbracket-circumflex-slash-rightbracket matches any single character
> other than a slash.  The asterisk following this pattern causes a match
> with zero or more characters (as many as possible, in fact) preceding it
> - in this case the bracketed string.  So the bracketed part followed by
> the asterisk together match as many characters as possibly not including
> a slash.  The dollar sign locks the pattern to the end of a paragraph -
> in this case, the end of the entire text in the cell.  So the whole
> string finds a slash followed by many not-slash characters, but only at
> the end of the string.  As you say, that means everything from the last
> slash in the string to the end.  The SEARCH() function then returns the
> position of the start of the matched text: the position of the last slash.

thank you very much, I understood now, and I will better study regular 
expressions...:-)
as you know is there some way to start search from the right of strings??

> > ...a couple of beer paid for you...:-) :-) :-)
>
> How kind!  I'll enquire of my mail service provider how soon they can
> permit liquid attachments.

...in technology we trust..... for now only USB beer... :-) :-) :-) :-)
http://beer.about.com/od/beertastinganddrinking/ig/Beer-Gadgets--Gizmos---Goodies/-Beer--Filled-USB-Flash-Drive.htm
but I don't know the flavour...
...and if you pass from Latina-Italy email to me, a real beer can be 
found more easily...:-) :-)

> I trust this helps.
>
> Brian Barker
ciao, Pier

P.S. sorry if my bad english can generate misunderstunding, I'm only 
joking :-)

--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
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