SetURLParameter ( urlString ; parameterName ; text )

Sets a specific parameter inside a urlString to some text

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

Gary Amstutz - Show more from this author
Sweetwater
http://sweetwater.com

Sample input:

SetURLParameter ( "http://www.examples.com/search?category=shoe&brand=nike&color=red&size=5&pricefrom=10&priceto=1000" ; "brand" ; "newbalance" )

or

SetURLParameter ( "http://www.aircraft.com/search?make=&model=" ; "make" ; "airbus" )

Sample output:

http://www.examples.com/search?category=shoe&brand=newbalance&color=red&size=5&pricefrom=10&priceto=1000

or

http://www.aircraft.com/search?make=airbus&model=

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

Let
(
[
 paramDelimiter = "&"; // change this if you need a different paramDelimiter (or pass as 4th paramater)
 paramStarter = "?"; // change this if you need a different starting parameter character (or pass as 5th parameter)

 urlLen = Length ( urlString );
 loc = Position ( urlString; paramStarter; 1; 1 );
 paramList = Right ( urlString; Length ( urlString ) - loc );
 paramSearch = paramDelimiter & parameterName & "=";
 len = Length ( paramSearch ) ;
 locStart = Position ( paramList; paramSearch; 1; 1 ) + len - 1;
 locEnd = Position ( paramList; paramDelimiter; locStart; 1 );
 param = Left ( urlString; loc) & Left ( paramList; locStart ) & text 
         & If ( locEnd > 0; Middle ( paramList; locEnd; urlLen ) )
];
 param
)

Sometimes you need to set a parameter in a URL based on data in a field in a record in FileMaker. This function simplifies that task. You can call this function repeatedly with different parameter names and data to set multiple parameters within the same URL.

Comments

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

SetURLParameter ( urlString ; parameterName ; text )

Comments

Support this website.

Support this website.