DeleteMiddleText ( Value ; StringStart ; StringEnd )

Delete text between markers

Average rating: 4.8 (29 votes) Log in to vote

Ruben van den Boogaard - Show more from this author
Infomatics
http://www.infomatics.nl

Sample input:

DeleteMiddleText ( "This <#< LEAF THIS OUT >#> is my text" ; "<#<" ; ">#>" )

Sample output:

"This is my text"

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

//DeleteMiddleText ( Value ; StringStart ; StringEnd )

Case (
Position ( Value ; StringStart ; 1 ; 1 )=0 ; Value ;

//get the part before and after the StringStart en StringEnd

Let ([
Start = Left(value ; Position ( Value ; StringStart ; 1 ; 1 )-1) ;
End= Middle(Value ; Position ( Value ; StringEnd ; Length( Start ) ; 1 )+ Length( StringEnd ) ; Length( Value ));
Value= Start & End
];

//Run the recursion again

DeleteMiddleText ( Value ; StringStart ; StringEnd)

)
)

This is a recursive CF to delete blocks of text marked between StringStart and StringEnd

Comments

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

DeleteMiddleText ( Value ; StringStart ; StringEnd )

Comments

Support this website.

Support this website.