Skip to main content
Question

Removing .pdf from a file name

  • Nov 14, 2019 4:30 PM UTC
  • 0 replies
  • 372 views

Forum|alt.badge.img+14
Trying to remove .pdf from the end of the file name. Using a formula text field I attempted to use the function Part([File],1,".") , but my file name will often have periods (different amounts) so I can't seem to get that to work, unless there is a way to use it I'm not thinking of.

I tried to use the function Left([File],".pdf"), but that still only looks at the period and not the entire string.

How can I remove the .pdf from a file name, where the file name includes periods?

------------------------------
Mike Tamoush
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Try
NotRight([File],".")

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------