Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 

 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

PathParser ( thePath ; returnElementPHFNE )

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 4.6  (12 votes)
  Discuss this Custom Function

Lewis Lorenz, Lorenz Companies
http://www.LorenzCom.com

PathParser returns the directory path, home directory, full filename and extension, filename, or extension from a folder and/or file path string.

Sample Input:
PathParser ( "file:" & Get ( DocumentsPath ) & "Untitled.pdf" , "p" )
PathParser ( Get ( DocumentsPath ) & "Untitled.pdf" , "h" )
PathParser ( Get ( DocumentsPath ) & "Untitled.pdf" , "fullfilename" )
PathParser ( Get ( DocumentsPath ) & "Untitled.pdf" , "n" )
PathParser ( Get ( DocumentsPath ) & "Untitled.pdf" , "e" )
PathParser ( Get ( DocumentsPath ) & "Untitled.pdf" , "2" )
PathParser ( Get ( DocumentsPath ) & "Untitled.pdf" , "-1" )
Sample Output:
file:/Macintosh HD2/Users/user/Documents/
/Users/user/Documents/
Untitled.pdf
Untitled
pdf
/user/Documents/
/Macintosh HD2/Users/user/


 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

PathParser ( thePath , returnElementPHFNE )

PathParser returns the directory path, home directory, full filename and extension, filename, or extension from a folder and/or file path string.

- Easily extract path elements from thePath.
- Preserves FileMaker Pro file reference prefixes (file:, filemac:, and filewin:).
- Omit directories forwards or backwards from thePath.
- The home or ~ (tilde) element request returns the home path - path without Get ( SystemDrive ) prepended.
- Works with the thePath string as passed - it does not format thePath, except to prepend a missing path separator when returning path or home requests.
- Uses the leftmost path separator in thePath to delineate path elements.
- Use with the PathMaker custom function for added path formatting control.

Parameters:

- thePath - A folder and/or file path.
- returnElementPHFNE - The element in thePath to return. Determined from the first letter of the passed parameter or the number:
- [p]ath: Returns the directory path, without the filename and extension.
- [h]ome or ~: Returns the home directory path, without the system drive information.
- [f]ullfilename: Returns the filename and extension, without the path directory.
- [n]ame: Returns the filename, without the path directory and without the file extension.
- [e]xtension: Returns the file extension, without the path directory and without filename.
- [+/-#]: Returns the path after omitting the specified number (#) of directories from the left or right of thePath.
- A positive number omits directories forwards from the left.
- A negative number omits directories backwards from the right.

Examples:

- PathParser ( "file:" & Get ( DocumentsPath ) & "Untitled.pdf" , "p" ) = file:/Macintosh HD2/Users/user/Documents/
- PathParser ( Get ( DocumentsPath ) & "Untitled.pdf" , "h" ) = /Users/user/Documents/
- PathParser ( Get ( DocumentsPath ) & "Untitled.pdf" , "fullfilename" ) = Untitled.pdf
- PathParser ( Get ( DocumentsPath ) & "Untitled.pdf" , "n" ) = Untitled
- PathParser ( Get ( DocumentsPath ) & "Untitled.pdf" , "e" ) = pdf
- PathParser ( Get ( DocumentsPath ) & "Untitled.pdf" , "2" ) = /user/Documents/
- PathParser ( Get ( DocumentsPath ) & "Untitled.pdf" , "-1" ) = /Macintosh HD2/Users/user/

Help:

- Passing '?' as the leftmost text in returnElementPHFNE returns this help text: PathParser ( thePath , returnElementPHFNE: [p]ath, [h]ome or [~], [f]ull name and extension, [n]ame, [e]xtension), [+/-#] omit # of directories ).

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

This is my Custom Function and I want to edit it

Discuss:

I updated this function 10/23/2016 to allow skipping directories in thePath. User can send a positive or negative number in the returnElement parameter to skip directories either forward from the left or backwards from the right.

Lewis Lorenz, Tulsa
October 23, 2016 3:30pm

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
City/Location:
Comment:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 8 + 3 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. ProperAllWords ( text )
  (Thu, Dec 14, 5:19pm)
2. MatchExist ( SourceTable.Field ; DestTable.Field ; ReturnField )
  (Thu, Dec 14, 1:07pm)
3. BVR_Format ( bvr )
  (Wed, Dec 13, 5:32pm)
4. NumberToHexadecimal(NumberValue)
  (Fri, Dec 08, 8:54am)
5. Get_BaseTable
  (Thu, Dec 07, 4:27pm)
6. JSONCreateVarsFromKeys ( json ; namespace )
  (Wed, Dec 06, 8:21pm)
7. GetTableNzme ( field )
  (Tue, Dec 05, 9:16pm)
8. TimeFormatAsText ( theTime )
  (Mon, Nov 13, 1:59pm)

RSS Feed of Custom Functions