Brian Dunning's FileMaker Custom Functions

SP ( ID )

Gets Value ID from a Script Parameter

  Average rating: 4.8 (31 votes) Log in to vote

Aaron Koenes   Aaron Koenes
Michigan Industrial Tools
http://www.mit-tool.com

Share on Facebook Share on Twitter

  Sample input:
"FirstĀ¶SecondĀ¶Third"
  Sample output:
Second

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

I often use script parameters which send a carriage return delimited list of values. When parsing out these values in scripts, it became annoying to repeatedly type GetValue( Get( ScriptParameter ) ; 1 ). By using this custom function, all that needs to be typed is SP( 1 ). Seems like a small change, but has saved me a huge amount of time.

 

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.

Under construction. Email me your wish list for improvements.