Brian Dunning's FileMaker Custom Functions

my ( )

uses the current field. This is especially helpful for Replace operations which you do perform on the actual field.

  Average rating: 5.0 (1 vote) Log in to vote

Martin Trautmann   Martin Trautmann - Show more from this author
MYX Design

Share on Facebook Share on Twitter

  Sample input:
my () /* nothing more, just use the function without any parameters */
  Sample output:
/* the contents of the current field, */
/* for a Replace operations across all records */

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

When you use a Substitute function for a Replace within your current set of found records,
you usually have to type this as

Substitute( $YourField, "X", "Y")

With this custom function this simplifies to

Substitute( my ; "X" ; "Y" )

regardless of the field you currently use.

When you use Substitute even more often, extend that with a custom function

s (searchString ; replaceString) =
Substitute ( my ; searchString ; replaceString )

and use that as e.g. s("X"; "Y")


 

Comments

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: