Brian Dunning's FileMaker Custom Functions

PickTag ( Text ; Prefix ; Suffix )

Pick strings between Prefix and Suffix with Prefix and Suffix itself.

  Average rating: 4.7 (26 votes) Log in to vote

Koji Takeuchi   Koji Takeuchi
TonicNote, Inc.
https://tonic-note.com

Share on Facebook Share on Twitter

  Sample input:
PickTag ( "abc<>def<>" ; "<<" ; ">>" )
  Sample output:
<>¶<>

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

PickTag ( Text ; Prefix ; Suffix )
2012.09.07, Koji Takeuchi


description:
Pick strings between Prefix and Suffix with Prefix and Suffix itself.
ex.
Text = "abc<>def<>"
PickTag ( Text ; "<<" ; ">>" )
= "<>¶<>"

If you want to pick strings without Suffix and Prefix, try PickTagContent ( Text ; Prefix ; Suffix ).

 

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.