getSelected ( parameterCode )

get all kinds of selection values

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

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

Sample input:

text = MaryGoesAway with Goes selected

getSelected ( 12 );
getSelected ( 13 );
getSelected ( fc );
getSelected ( 2 );

Sample output:

MaryGoes;
MaryAway;
MaryGoesAway;
Goes;

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

Let([
	fieldContent	= Get ( ActiveFieldContents );
	fieldName		= Get ( ActiveFieldTableName ) & "::" & Get ( ActiveFieldName );
	selectionStart	= Get ( ActiveSelectionStart ) ;
	selectionSize	= Get ( ActiveSelectionSize ) ;
	selectionEnd	= selectionStart + selectionSize - 1 ;
	part1	 	= Left ( fieldContent ; selectionStart - 1 );
	part2		= Middle ( fieldContent ; selectionStart ; selectionSize );
	part3		= Right ( fieldContent ; Length ( fieldContent ) - selectionEnd )
];
	Case (
		parameterCode = "1" ; part1 ;
		parameterCode = "2" ; part2 ;
		parameterCode = "3" ; part3 ;
		parameterCode = "12" ; part1 & part2;
		parameterCode = "23" ; part2 & part3 ;
		parameterCode = "13" ; part1 & part3 ;
		parameterCode = "start" ; selectionStart ;
		parameterCode = "size" ; selectionSize ;
		parameterCode = "end" ; selectionEnd ;
		parameterCode = "fn" ; fieldName ;
		parameterCode = "fc" ; fieldContent ;
		""
	)
)

Simple formula to get all the possible (maybe) selection one may want. Easy to do but handy if already done

Comments

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

getSelected ( parameterCode )

Comments

Support this website.

Support this website.