Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Brampton, Ontario, Canada
    Posts
    27

    Unanswered: Trim the last 4 Characters from a string

    Using Access2000
    How would I take the last 4 characters from a String.

    i.e. I have various text files and I want to remove the ".txt" from the file names.

  2. #2
    Join Date
    Oct 2001
    Location
    Chicago
    Posts
    440
    Left(string,Len(string)-4) will remove the extension

    Right(string,4) will yield the extension

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •