Find backslash position in a string with partition function

[john9210]

I’m trying to extract the filename from a file path. For example: Path = C:\Maintenance\System\Temperature Guide.docx.

It seems the position function does not operate on “backslashes”. When I try to find the first backslash from the right, I get the error message that the text constant does not end with a quotation mark.

Position(Path,“\”,-1,1)

[doughemi]

Backslash is a character reserved by FileMaker to "escape" the next character. You wlll have to tell FileMaker to treat the backslash as a literal character by preceeding it with another:

Position(Path; ""; -1; 1)

http://help.filemake...n-filemaker-pro