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 - Show more from this author
TonicNote, Inc.
https://tonicnote.com

Sample input:

PickTag ( "abc<>def<>" ; "<<" ; ">>" )

Sample output:

<>¶<>

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

/*
PickTag ( Text ; Prefix ; Suffix )
2011.09.07, Koji Takeuchi <takeuchi@nemoux.com>


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


Case (
PatternCount ( Text ; Prefix ) and PatternCount ( Text ; Suffix ) ;

Let (
[
start =
	Position ( Text ; Prefix ; 1 ; 1 ) ;
end =
	Position ( Text ; Suffix ; 1 ; 1 ) + Length ( Suffix ) ;
target =
	Middle ( Text ; start ; end - start ) ;
rest =
	Right ( Text ; Length ( Text ) - end + 1 ) ;
more =
	PatternCount ( rest ; Prefix ) and PatternCount ( rest ; Suffix )
] ;

target & 
Case (
more > 0 ;
¶ & PickTag ( rest ; Prefix ; Suffix )
)


) ; // Let

""

) // Case

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

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

PickTag ( Text ; Prefix ; Suffix )

Comments

Support this website.

Support this website.