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

[Coolboy]

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, 2006 by Guest