Name & Parameters: Extract ( source ; start ; end ) Description: Extracts data from HTML text when using the Filemaker web viewer Sample Input: First, here is a sample HTML string from

Name & Parameters: [color:red][big] Extract ( source ; start ; end ) [/big]

Description: Extracts data from HTML text when using the Filemaker web viewer

Sample Input:

First, here is a sample HTML string from where you want to extract the state for an address from whitepages.com:

TML_STATE_ESC_=NY&

The function would be:

Extract("TML_STATE_ESC_=NY&","TML_STATE_ESC_=","&")

Results:

NY

Recursive: no

Formula:

Middle (source ; Position ( source ; start ; 1 ; 1 ) + Length ( start ) ; Position ( source ; end ;Position (source; start ; 1 ; 1 ) ; 1 )-(Position ( source ; start ; 1 ; 1 ) + Length ( start ))) 

Required Functions: GetLayoutObjectAttribute ( objectName ; attributeName {; repetitionNumber ; portalRowNumber} )

Author(s) Julio C. Plasencia

Date: 07/18/06

Credits:

Disclaimer:

FM Forums does not endorse or warrantee these files are fit for any particular purpose. Do not post or distribute files without written approval from the copyright owner. All files are deemed public domain unless otherwise indictated. Please backup every file that you intend to modify.

Whitepages.zip

Edited July 19, 200619 yr by Guest