HTML_Parser_Cell ( Source_Field ; Start_String ; Start_Occurrence ; Middle_String ; Middle_Occurrence ; Middle_Gap ; End_String ; End_Oc

HTML Parser Cell

Average rating: 4.2 (35 votes) Log in to vote

Joel Englander
Joel Englander
http://www.asymptotes.com

Sample input:

Set field: Example
Set Field [ FR Designer::Fiche City;
HTML_Parser_Cell (
FR Designer::Fiche HTML ;
"" ; 1 ;
"" ; 2 ; 0 ;
"" ; 3 ; 6
) ]

Sample output:

Hudson

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

Let ( [
$Position_Start = Position ( Source_Field ; Start_String ; 1 ; Start_Occurrence ) ;
$Position_Middle = Position ( Source_Field ; Middle_String ; $Position_Start ; Middle_Occurrence ) + Length ( Middle_String ) + 1 + Middle_Gap ;
$Position_End = Position ( Source_Field ; End_String ; $Position_Start ; End_Occurrence ) - 1 - End_Gap - $Position_Middle ] ; 
Middle ( Source_Field ; $Position_Middle ; $Position_End )
)

Function : Application :
HTML_Parser_Cell (
Source_Field ;
Start_String ; Start_Occurrence ;
Middle_String ; Middle_Occurrence ; Middle_Gap ;
End_String ; End_Occurrence ; End_Gap
)
_________________________________________
HTML : Exemple : FR Designer::Fiche HTML :

A. Michael Krieger Inc.

441 Warren Street

Hudson
,
NY

12534

Comments

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth:

Nope