Brian Dunning's FileMaker Custom Functions

ParseScriptParam ( Iteration ; Seperator )

Grabs data from a concatinated script parameter

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

Tim Flynn   Tim Flynn
beezwax datatools
http://www.beezwax.net

Share on Facebook Share on Twitter

  Sample input:
ParseScriptParam(0;"|")
  Sample output:
MyRecordID

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

Do you build dynamic data into your script parameters? I do - often concatinating strings of data with a unique seperator. I might grab from a portal row my record ID, creation date, modifier, and other values to pass on to a script. This custom function allows you to build custom strings of data separated by the character of your choice and then easily pull it out by providing the custom function with the starting position of your chosen separator. Use zero to grab the first set of characters. It grabs from left to right.

 

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.