[libreoffice-users] regular expression in formula to investigate

I found this very beautiful and useful formula to estract filename in a 
cell:

=REPLACE(REPLACE(CELL("filename"),FIND(".",CELL("filename"),1),(LEN(CELL("filename"))-FIND(".",CELL("filename"),1)+1),""),1,SEARCH("/[^/]*$", 
CELL("filename")),"")

I cannot understand this part:
SEARCH("/[^/]*$", CELL("filename")
I know it search in CELL("filename")
but I cannot understund 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 eapressions here used??

...a couple of beer paid for you...:-) :-) :-)

manythanks, ciao, pier

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