Re: gnumeric-list Digest, Vol 145, Issue 1
- From: Morten Welinder <mortenw gnome org>
- To: Jean Brefort <jean brefort free fr>
- Cc: Chris Dunn <chris iccqs com>, Gnumeric Mailing List <gnumeric-list gnome org>
- Subject: Re: gnumeric-list Digest, Vol 145, Issue 1
- Date: Sun, 31 Jul 2016 19:46:13 -0400
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
[
Date Prev][Date Next] [
Thread Prev][Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]