@ ( word )

returns a number for a word, to allow variables to have named repetitions

Average rating: 5.0 (1 vote) Log in to vote

Hisc - Show more from this author
noplace
http://nourl

Sample input:

@ ( "john" )
@ ( "$$john" )

Sample output:

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

Let([
	global = If ( Left ( word ; 2 ) = "$$" ; 1 ; 0 ) ;
	word =  If ( Left ( word ; 2 ) = "$$" ; Right ( word ; Length ( word ) - 2 ) ; word ) ;
	text = If ( global ; $$CF_@_orderForWord ; $CF_@_orderForWord ) ;
	string = "<<<" & word & ">>>" ;
	stringend = "<<</" & word & ">>>" ;
	pos01 = Position ( text ; string ; 1 ; 1 ) ;
	pos02 = Position ( text ; stringend ; pos01 + Length ( string ) ; 1 ) ;
	number = If (
		pos01 and pos02 ; 
			Middle ( text ; pos01 + Length ( string ) ; pos02 - ( pos01 + Length ( string ) ) ) ;
			""
	)
];
	If (
		not IsEmpty ( number ) ;
			number ;
			Let ( [
				maxOrder = PatternCount ( text ; "<<</" ) ;
				newOrder = maxOrder * 2 + If ( global ; 1 ; 0 ) + 2;
				_ = If (
					global ;
						Let ( $$CF_@_orderForWord = text & "<<<" & word & ">>>" & newOrder & "<<</" & word & ">>>" ; "" ) ;
						Let ( $CF_@_orderForWord = text & "<<<" & word & ">>>" & newOrder & "<<</" & word & ">>>" ; "" )
				)
			] ;
				newOrder
			)
		)
)

FileMaker makes it easy to create variables with numbered repetitions, like $var[1], but not variables with named repetitions, like $var["john"]

this function allows a pseudo-named repetition, as it creates a numbers to represent the word within the context. For example: $var[@("john")]

if one wants a persistent and global number, just use parameter that starts with "$$" like @("$$john")

global numbers are always odd, while local are always even.

Comments

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

@ ( word )

Comments

Support this website.

Support this website.