Conditional Expressions ( txt )

Wrap text content in conditional expressions.

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

Daniel - Show more from this author
https://inexi.com

Sample input:

Conditional Expressions ( "... {if 1 + 1 = 2
I will be included!} ..." )

Sample output:

... I will be included! ...

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

/*** Conditional Expressions ( txt )

Evaluates text for conditional expressions wrapped in {} brackets.

Format:
{if [expression]
[content]}

Example:
{if 1 + 1 = 2
Yay!

I will be included!
}{if 2 + 2 = 2
I will not be included.
}

***/
Let([
	oT = "{if " ;
	oTlen = Length ( oT ) ;
	cT = "}" ;

	S1 = Position ( txt ; oT ; 1 ;1 ) ;
	S2 = Position ( txt ; ¶ ; S1 ; 1 ) ;
	E = Position ( txt ; cT ; S2 ; 1 ) ;

	valid = S1 and S2 and E ;
	statement = If ( valid ; Middle ( txt ; S1 + oTlen ; S2 - S1 - oTlen ) ) ;
	result = If ( IsValidExpression (statement) ; Evaluate(statement) ; False ) ;
	txt = If ( valid ; Left( txt ; S1 - 1 ) & If ( result ; Middle ( txt ; S2 + 1 ; E - S2 - 1 ) ) & Right ( txt ; Length(txt) - E ) ; txt ) ;

	more = valid and PatternCount ( txt ; oT ) and PatternCount ( txt ; cT )
];
	If ( more ; Conditional Expressions ( txt ) ; txt )
)

This has not been tested extensively, use it at your own risk or as a starting point! ;) As you can see above, it is recursive, there will be limits to this.

It assumes the expression to test begins after the opening tag ("{if " by default) and ends with a line break/¶.

It's easy to change the opening tag ("oT") and closing tag ("cT").

Comments

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

Conditional Expressions ( txt )

Comments

Support this website.

Support this website.