ParseText ( Text, BeginText, EndText )
Parses text from an e-mail message generated by a custom form
Average rating: 4.3 (32 votes) Log in to vote
Tim Cimbura - Show more from this author
Function definition: (Copy & paste into FileMaker's Edit Custom Function window)
The custom function is very useful to pull items out of any e-mail message that has been sent via a web form. It will look for a return, tab, space, or no delimiter between the BeginText and the start of the field info.
Roger Biel, Casa Grande, Arizona
May 13, 2011
By Adding a test for both the Begin & End text the result will return NULL if the markers are missing.
Case( PatternCount ( Text ; BeginText ) < 1;""; PatternCount ( Text ; EndText ) < 1;"";
Position(Chunk1; EndText; 1; 1)-1);"" )
Jul 14, 2015
|This function doesn't seem to work if the "BeginText" represents the first characters in "Text"...|
Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.