Discussions

Expand all | Collapse all

Removing .pdf from a file name

  • 1.  Removing .pdf from a file name

    Posted 29 days ago
    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
    ------------------------------


  • 2.  RE: Removing .pdf from a file name

    Posted 29 days ago
    Try
    NotRight([File],".")

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



  • 3.  RE: Removing .pdf from a file name

    Posted 29 days ago
    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
    ------------------------------