GetProperty ( propertyList ; propertyName ; separator )

Extract a property's value from a property list with a separator

Average rating: 4.5 (28 votes) Log in to vote

Koen Van Hulle
SHpartners
http://www.shpartners.com

Sample input:

GetProperty("height=200|width=6|color=red" ; â��widthâ�� ; â��|â��)

Sample output:

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

Let( [ 
countequalsign = PatternCount(propertyList ; "="); 
countseparator =  PatternCount(propertyList ; separator); 
lengthproperty = If(countequalsign=1 ; Length(propertyList) ; Position(propertylist ; separator ; 0 ; 1) -  1 ) 
; 
nextpropertylist = Right( propertylist ; Length(Propertylist) 
- lengthproperty- 1) ; 
myproperty = Left(propertylist ; Position(propertylist ; "=" ; 0 ; 1) - 1); 
myvalue = Middle(propertylist ; Position(propertylist ; "=" ; 0 ; 1) + 1 ; lengthproperty - Position(propertylist ; "=" ; 0 ; 1) ) 
] 
; 
Case 
 ( 
 IsEmpty(separator) ; "Separator is empty" ; 
 IsEmpty(Propertylist) ; "Propertylist is empty" ; 
 IsEmpty(Propertyname) ; "Propertyname is empty" ; 
 countseparator = 0 and countequalsign <> 1 ; "wrong separator" ; 
  
   If 
   ( 
    propertyname = myproperty 
   ; 
   myvalue 
   ; 
      If 
      ( 
      IsEmpty(nextpropertylist) 
      ; 
       "NOT FOUND"  
      ; 
      GetProperty(nextpropertylist ; propertyName ; separator) 
      ) 
   ) 
 ) 
)

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

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

Comments

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

GetProperty ( propertyList ; propertyName ; separator )

Comments

Support this website.

Support this website.