Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
6 years ago

Removing .pdf from a file name

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
------------------------------
    • MichaelTamoush's avatar
      MichaelTamoush
      Qrew Captain
      Once again, I worked on this for an hour, posted here, immediately figured it out after posting, and came back to update the post - and you beat me to it. Lol. Thanks!

      ------------------------------
      Mike Tamoush
      ------------------------------