ExtractFromText ( TextBody ; keyText )
Returns strings/values from text
Average rating: 4.4 (34 votes) Log in to vote
|
Tim Anderson - Show more from this author
Tim Anderson Group |
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
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.