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+unsubscr...@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