On 19-10-2012 16:23, Samuele Zampini wrote:
I solved it with this formula:
=REPLACE(REPLACE(CELL("filename");FIND(".";CELL("filename");1);(LEN(CELL("filename"))-FIND(".";CELL("filename");1)+1);"");1;SEARCH("/[^/]*$";
CELL("filename"));"")
I like it!
its a bit too long ....
i would like CELL("shortfilename") more
CELL("Filename") should return just the name (without path)
and CELL("path") to return the path
but that is obviously not possible because Microsoft 'invented' it the
other way.... ;(
and why is there no mentioning in the help page that we can use a
regular expression to search with SEARCH()...?
--
For unsubscribe instructions e-mail to: [email protected]
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
