 Rank: Newbie
Groups: Registered
Joined: 16/11/2022(UTC) Posts: 2  Location: Lichtenvoorde
|
Hello All,
i am a new user of Smath.
When we use the field "file name" it will display the filename with the complete path.
Is it possible to display only the file name with the Extension
Friso
|
|
|
|
|
|
  Rank: Advanced Member Groups: Registered
Joined: 11/01/2018(UTC) Posts: 122   Location: Wisconsin Was thanked: 56 time(s) in 35 post(s)
|
Greetings! This is a great question! As such, I took the past few days researching it and the answer I have to your question is: "kind·a" As you said, inserting a FIELD will result in the full filepath and I have not been able to 'format' this field to report just the filename. However, Page Setup handles these fields differently! As such, referencing &[FILENAME] as an entry into the Header/Footer will print the filename without the filepath.
Please note, that the Page Setup Header/Footer inputs will only populate if the Header/Footer regions of your Worksheet are left blank.
 Hope this of help! - Kenny Lemens, P.E. ᵂᴵ |
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 16/11/2022(UTC) Posts: 2 Location: Lichtenvoorde
|
Hello Kenny,
Thanks for your solution and we are going to use this in the future.
If it good by as a format in the insert field, we would prefer this.
Friso
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
