getParameter ( FieldContent ; Number )

get Parameter - set a global field with multiple fields with a pipe bar between them, then be able to extract the data out

Average rating: 4.6 (30 votes) Log in to vote

Timothy Brown
Antidote Solutions
http://www.antidotesolutions.com

Sample input:

_gField =Tim|Brown|Antidote|756|

getParameter(_gfield,3)

Sample output:

Antidote

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

/*The pipe bar must be used to identify  the next field and must end in a pipe bar
great for passing data between tables */

Let( [
Begin = Position(FieldContent; "|"; 1; number - 1) + 1;
End = Position(FieldContent; "|"; 1 ; Number) - Begin
];

Middle(FieldContent; begin;  end))

Sometimes when you move from record to record and table to table you want to bring record information with you. Instead of creating a global field for each field you need, you can create just one global field and store the field contents to be pulled out later.

Comments

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

getParameter ( FieldContent ; Number )

Comments

Support this website.

Support this website.