Newest functions Upload a function Leave a tip My account

There are 2,521 functions in this library.

ParseScriptParam ( Iteration ; Seperator )

Grabs data from a concatinated script parameter

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

Tim Flynn - Show more from this author beezwax datatools http://www.beezwax.net

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

Middle ( Get ( ScriptParameter ) ; Position ( Get ( ScriptParameter ) ; Seperator ; 0 ; Iteration ) + If(iteration=0;0;1); ( If(Iteration = PatternCount ( Get ( ScriptParameter ) ; Seperator );Length ( Get ( ScriptParameter ) ) - Position ( Get ( ScriptParameter ) ; Seperator ; 0 ; Iteration ); Position ( Get ( ScriptParameter ) ; Seperator ; 0 ; Iteration +1 ) - Position ( Get ( ScriptParameter ) ; Seperator ; 0 ; Iteration )-1) ) ) Click to copy

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.

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: