Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Offline Friso Oonk  
#1 Posted : 18 November 2022 12:11:05(UTC)
Friso Oonk

Rank: Newbie

Groups: Registered
Joined: 16/11/2022(UTC)
Posts: 2
Netherlands
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
Offline Kenny Lemens  
#2 Posted : 23 November 2022 02:31:25(UTC)
Kenny Lemens


Rank: Advanced Member

Groups: Registered
Joined: 11/01/2018(UTC)
Posts: 38
Man
United States
Location: Wisconsin

Was thanked: 9 time(s) in 7 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.

SMath_filenameWithoutFilePath.jpg


Hope this of help!

- Kenny Lemens, P.E. ᵂᴵ
Offline Friso Oonk  
#3 Posted : 23 November 2022 12:41:53(UTC)
Friso Oonk

Rank: Newbie

Groups: Registered
Joined: 16/11/2022(UTC)
Posts: 2
Netherlands
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
Users browsing this topic
Similar Topics
wfile and rfile no underscore in file name (Questions)
by RFreund 02/11/2021 00:51:00(UTC)
Get current file name (Questions)
by TheWizEd 15/08/2010 20:47:58(UTC)
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.