GetProperty ( propertyList ; propertyName )

Extract a property's value from a property list

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

Shaun Flisakowski
spf-15
http://www.spf-15.com/

Sample input:

GetProperty ( "left=20¶top=80¶name=bill"; "top" )

Sample output:

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

If ( IsEmpty(propertyList); "";
     Let( [ firstProp = LeftValues( propertyList; 1 );
              eqlPosition = Position( firstProp; "="; 1; 1 );
              firstPropName = Left( firstProp; eqlPosition - 1 )
            ];
            If (firstPropName = propertyName;
                Middle( firstProp; eqlPosition+1; Length( firstProp ) - eqlPosition - 1 );
                GetProperty( RightValues( propertyList; ValueCount(propertyList) - 1 ); propertyName )
            )
      )
)

Extracts a single property's value from a newline seperated list of properties, by property name.

This function can be used to easily pass multiple named parameters into a script.

Comments

		Jeff Dressing Nov 10, 2020
How can this function be modified to bring back all instances of a property? So there could be several values with the same property name...

		Jeff Dressing Nov 11, 2020
How can this function be modified to bring back all instances of a property? So there could be several values with the same property name...

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

GetProperty ( propertyList ; propertyName )

Comments

Support this website.

Support this website.