Re: gnumeric-list Digest, Vol 145, Issue 1

[Morten Welinder <mortenw gnome org>]

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