GetFOI ( y ; m )

A simple function to get the FOI Index (from Italian ISTAT)

Average rating: 4.4 (30 votes) Log in to vote

Roberto Degano
DLV
http://www.deleveste.it

Sample input:

GetFOI ( 2001 ; 3 )

Sample output:

2,8

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

If ( y = "" or m = "" ; "" ;
Let ([
s1 = ">" & y & "<" ;
s2 = "+" ;
HTML = GetLayoutObjectAttribute ( "Web" ; "content" ) ;

start1 = Position ( HTML ; s1 ; 1 ; 1 ) ;
end1 = Position ( HTML ; s1 ; 1 ; 2 ) ;
text1 = Middle ( HTML ; start1 ; end1 - start1 ) ;

start2 = Position ( text1 ; s2 ; 1 ; m ) ;
text2 = Middle ( text1 ; start2 ; 6 )
] ;

Filter ( text2 ; "0123456789," ) / 100
)
)

Returns the FOI Index from a WebViewer showing the adress "http://www.istat.it/prezzi/precon/rivalutazioni/variaz1a.html"

Migliorata un po' grazie al contributo di Book

Comments

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

GetFOI ( y ; m )

Comments

Support this website.

Support this website.