Brian Dunning's FileMaker Custom Functions

StringConstruct ( text ; prefix ; suffix ; altText )

Shows a value if present with an option prefix and suffix, otherwise shows alternate text

  Average rating: 4.0 (51 votes) Log in to vote

Chad Sager   Chad Sager
IT Solutions Consulting, Inc.
http://www.itsolutions-inc.com/Filemaker

Share on Facebook Share on Twitter

  Sample input:
Student::Name & " is " & StringConstruct ( Student::Age; "an "; " year old" & StringConstruct ( Student::Gender; " "; "."; " person." ); StringConstruct ( Student::Gender; ""; "."; "a person." ) )
  Sample output:
Joe is an 18 year old male.

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

PURPOSE: used to concatenated text strings, extremely useful when trying to build natural language text strings.
You can point to a text value, if its empty, only the Alt text will display if provided.
If there is a value for the text the prefix and suffix will show, if provided.

PARAMETERS:
text - the text you want to display
prefix - a prefix to the text
suffix - a suffix to the text
altText - an alternate text to show if the primary text is empty

IMPORTANT NOTES: remember if you want any or all the parameters to be empty, just use "" (double quotes)


EXAMPLES:
Student::Name = "Joe"
Student::Gender = "male"
Student::Name & " is " & StringConstruct ( Student::Gender; "" ; "." ; "a person." )
Returns "Joe is male."

Student::Name = "Joe"
Student::Gender = ""
Student::Name & " is " & StringConstruct ( Student::Gender ; "" ; "." ; "a person." )
returns "Joe is a person."

Student::Name = "Joe"
Student::Gender = "male"
Student::Age = 18
Student::Name & " is " & StringConstruct ( Student::Age; "a "; " year old" & StringConstruct ( Student::Gender; " "; "."; " person." ); StringConstruct ( Student::Gender; ""; "."; "a person." ) )
Returns:
"Joe is a 18 year old male."

Student::Name = "Joe"
Student::Gender = ""
Student::Age = 18
Student::Name & " is " & StringConstruct ( Student::Age; "an "; " year old" & StringConstruct ( Student::Gender; " "; "."; " person." ); StringConstruct ( Student::Gender; ""; "."; "a person." ) )
Returns:
"Joe is a 18 year old person."

Student::Name = "Joe"
Student::Gender = ""
Student::Age = ""
Student::Name & " is " & StringConstruct ( Student::Age; "an "; " year old" & StringConstruct ( Student::Gender; " " ; "." ; " person." ) ; StringConstruct ( Student::Gender ; "" ; "." ; "a person." ) )
Returns:
"Joe is a person."

Student::Name = "Joe"
Student::Gender = "male"
Student::Age = 18
Student::Name & " is " & StringConstruct ( Student::Age ; "an " ; " year old" & StringConstruct ( Student::Gender ; " " ; "." ; " person." ) ; StringConstruct ( Student::Gender; "" ; "." ; "a person." ) )
Returns:
"Joe is male."

 

Comments

Log in to post comments.

 

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

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 15 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: