If the string file://foo/bar/baz is in A1, then a formula like
this should work.
=trim(right(substitute(A1,"/",rept(" ",len(A1))),len(A1)))
In general, Google is your friend.
See
http://stackoverflow.com/questions/18617349/excel-last-character-string-match-in-a-string
Morten
On Sat, Jul 30, 2016 at 4:15 PM, Jean Brefort <jean.bref...@free.fr> wrote:
> Le samedi 30 juillet 2016 à 14:25 -0500, Chris Dunn a écrit :
>> On Sat, 30 Jul 2016 18:26:45 +0200
>> Jean Brefort <jean.bref...@free.fr> wrote:
>>
>> >
>> > Le samedi 30 juillet 2016 à 09:40 -0500, Chris Dunn a écrit :
>>
>> >
>> > >
>> > > Slightly off-topic I guess, but is there any way of inserting the
>> > > entire spreadsheet name into a cell?
>> > >
>> > > Thanks.
>> > >
>>
>> >
>> >
>> > Ty something like =cell("filename",A1)
>> >
>> > Regards,
>> > Jean
>>
>> Jean, thanks for this. It does work but it gives me the full path of
>> the filename as well as the file name like :
>>
>> file:///home/cdqs/Book1.gnumeric
>>
>> Is there any way of getting rid of the "///home/cdqs/"
>
> I don't know, and I actually did not find any sheet function to help
> with that. But it should be possible to write a new plugin function,
> either in C or Python, I suppose.
>
> Regards,
> Jean
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list@gnome.org
> https://mail.gnome.org/mailman/listinfo/gnumeric-list
_______________________________________________
gnumeric-list mailing list
gnumeric-list@gnome.org
https://mail.gnome.org/mailman/listinfo/gnumeric-list
