Brian Dunning's FileMaker Custom Functions

ExtractFromText ( TextBody ; keyText )

Returns strings/values from text

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

Tim Anderson   Tim Anderson
Tim Anderson Group

Share on Facebook Share on Twitter

  Sample input:
ExtractFromText ( "This is an example of the ExtractFromText function.¶¶Result:¶Yes, it works¶¶Another entry:¶something else here¶¶" , "Result:" )
  Sample output:
"Yes, it works"

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

Developed from a parsing script that extracted values from a form auto-emailed from a web page. The output is all text after the keyText and a paragraph return and up to consecutive paragraphs returns. If you want to tweak this for other symbols go ahead - very straightforward.

 

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.

Under construction. Email me your wish list for improvements.