Brian Dunning's FileMaker Custom Functions

LeftofSelection

Gets the strring to the left of the active selection text. If there is no selection, returns nothing

  Average rating: 4.0 (40 votes) Log in to vote

Rashid   Rashid
Spartantech
http://www.spartantech.net

Share on Facebook Share on Twitter

  Sample input:
Show me left "of this string"
(assuming "of this string is selected)
  Sample output:
Show me left

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Gets the strring to the left of the active selection text. If there is no selection, returns nothing

 

Comments

Lee Smith   Lee Smith
Jul 16, 2009
There a few typos in your CF.

You warned that this CF reqired a CF "GetSelectedText()", available here. That CF doesn't exist. However there is one called "getActiveSelection" that will work using your parameter.

In addition, the CF formula is not complete, as you used GetSelectedText without the parameter

Lee
 
Charles Sykora   Charles Sykora
Sep 15, 2019
This function does not work properly unless the selection if the first unique occurrence of the text
 

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: