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
LuminFire
http://luminfire.com

Sample input:

"City: Maple Grove¶State:¶MN¶Address: 123 Anywhere Street¶" ; "City:" ; "¶"

Sample output:

"Maple Grove"

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

Let ( [
ParseNum1 = Position (Text; BeginText & "¶"; 1; 1); // Look for Return as delimiter
ParseNum2 = If(ParseNum1=0; Position (Text; BeginText & "	"; 1; 1); ParseNum1); // Look for tab as delimiter
ParseNum3 = If(ParseNum2=0; Position (Text; BeginText & " "; 1; 1); ParseNum2); // Look for space as delimiter
ParseNum4 = If(ParseNum3=0; Position (Text; BeginText; 1; 1)-1; ParseNum3); // No delimiter

Chunk1 = If(ParseNum4<>0; Middle (Text; ParseNum4+Length(BeginText)+1; 99999);"")];
If(Chunk1<>""; Left(Chunk1; Position(Chunk1; EndText; 1; 1)-1);"" ))

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.

Comments

		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;""; Chunk1<>""; Left(Chunk1; Position(Chunk1; EndText; 1; 1)-1);"" )

		Sarah, Iowa 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.

ParseText ( Text, BeginText, EndText )

Comments

Support this website.

Support this website.