use a starting position of 1 instead of 0.
1 gives me the same problem. I just did a Google search and I've actually asked this same question before:http://forums.filemaker.com/posts/e010559c9b
I was referencing the manual, same as last time, and had the same confusion. The manual states: "A negative occurrence value causes the scan to go in the opposite direction from start."
If I give a start value of 0 (or 1 or anything else) and a negative occurrence value, the first thing I infer from this manual text is that the character search will "wrap around" from the beginning of the text string to the end. This apparently is not the case but that's not made implicitly clear to me.
Also, I'm still referencing the FM10 manual, for all I know this may have been addressed in subsequent revisions.
My mistake, did not see the - in the last parameter.
The position "search" does not wrap around. it searches from the specified start postion to the left until it reaches the start of the string.
Use this expression:
Let ( text = "/Volumes/Bicycle Records/MP3s/Agent Ribbons/and The Star-Crossed Doppelganger/01 The Wolf.mp3" ; Position( text ;"/"; length (text ) ;-2) )