[libreoffice-users] Re: Insert the filename in a cell

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: users+help@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