GetValueFromURLString ( paramname ; sourcecode )

Gets a parameter name from a URL string in an HTML document.

Average rating: 4.1 (41 votes) Log in to vote

Brian Dunning - Show more from this author
BrianDunning.com
https://www.briandunning.com

Sample input:

GetValueFromURLString ( "id" ; "a href=\"http://www.mysite.com?id=12345\"" )

Sample output:

12345

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

Case ( 

PatternCount ( sourcecode ; "?" & paramname & "=" ) = 0 and PatternCount ( sourcecode ; "&" & paramname & "=" ) = 0 ; "" ;

Let ( [

p1 = Position ( sourcecode ; "?" & paramname & "=" ; 1 ; 1 ) ;
p2 = Position ( sourcecode ; "&" & paramname & "=" ; 1 ; 1 ) ;

fieldpos = Case (
     p1 > 0 and p1 < p2 ; p1 ;
     p2 > 0 and p2 < p1 ; p2 ) ;

snip1 = Middle ( sourcecode ; fieldpos ; 99999 ) ;
valuepos = Position ( snip1 ; "=" ; 1 ; 1 ) ;
snip2 = Middle ( snip1 ; valuepos + 1 ; 99999 ) ;

ec1 = Position ( snip2 ; "\"" ; 1 ; 1 ) ;
ec2 = Position ( snip2 ; "&" ; 1 ; 1 ) ;

endchar = Case (
     ec1 < ec2 ; "\"" ;
     ec2 < ec1 ; "&" ) ;

endquotepos = Position ( snip2 ; endchar ; 1 ; 1 )

] ;

Left ( snip2 ; endquotepos - 1 )

 ) )

This searches an HTML document for any incidence of a URL containing the parameter you specify, and returns that parameter's value.

The parameter name must be preceded by either ? or & and the value must be followed by either a & or a ".

Comments

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

GetValueFromURLString ( paramname ; sourcecode )

Comments

Support this website.

Support this website.