Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 

 FileMaker Pro Custom Functions

List  |  Show Random  |  Upload  |  Add This to Your Site

DeleteVariableText ( Value ; StringStart ; StringEnd ; Pos ; Start ; End ) )

Rate this function:  

RatingRatingRatingRatingRating
  Average rating: 4.3  (36 votes)
  Discuss this Custom Function

Daniel Wood, Digital Fusion Ltd
http://www.digitalfusion.co.nz

Substitute out blocks of text, defined by a start/end string of characters - whose inner contents are of variable width

Sample Input:
RectangleArea ( This is (ID12)substituting out (ID9282)all instances of (ID)variable length bracketed stuff ; "(" ; ")" ; 1 ; "" ; "" )
Sample Output:
This is substituting out all instances of variable length bracketed stuff


 Then copy & paste into FileMaker Advanced's Edit Custom Function window.

Click here to copy To Clip Manager if you have myFMbutler's Clip Manager installed

Description:

This function enables you to substitute out blocks of text from a field where only the start and end characters of those blocks are known. For example, you might wish to substitute out all pieces of text which are enclosed in brackets, but whose inner contents of those brackets are unknown.

The function recursively by traversing the field, storing positions of the start & end characters when found - and when both a start and end are found, the block is removed, and traversal continues on the new piece of text.

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

This is my Custom Function and I want to edit it

Discuss:

5 most recent comments | Show all 7 comments

error in code:
StartPosition = If ( Middle ( Value ; Pos ; 3 ) = StringStart and IsEmpty ( Start ) ; Pos ; Start ) ;

should be 1 not 3...

Thanks for function though.

Thomas Seidler, London
September 02, 2012 9:55am

Just wanted to say thanks! I think it is wonderful that you would share this and it has saved me some real headaches. Worked a treat!

Katy Butterworth, New Zealand
July 20, 2014 4:25pm

No problem :) Hope all is well!

Daniel Wood, Christchurch, New Zealand
July 20, 2014 4:29pm

Sorry but there is missing the information what the Vars are for

Value = (Text?)
StringStart = ?
StringEnd = ?
Pos = ?
Start = ?
End = ?


Also the Example does not wor

Martin, Berlin
July 14, 2017 4:43pm

hi Martin,

Value - the text string you want to perform the function on
StringStart - This is the start string identifying the start of the block(s) of text to remove.
StringEnd - This is the end string identifying the end of the block(s) of text to remove.

Pos - Always set to 1 on first running the function.
Start/End - you can leave blank, these are parameters used in the recursion.

Unfortunately I have lost my password so cannot edit the function, but if you look up a few comments to a post by Thomas Seidler, you'll find the bug in the code that you can fix for the function to work.

cheers
Daniel

Daniel Wood, New Zealand
July 14, 2017 9:08pm

Make a comment about this Custom Function (please try to keep it brief & to the point). Anyone can post:

Your Name:
City/Location:
Comment:
characters left. If you paste in more than 1500 characters, it will be truncated. Discuss the function - advertisements and other useless posts will be deleted.
Answer 0 + 4 =
Search for Custom Functions:

Custom Functions Widget
Download the Custom Function Dashboard Widget for OS X
Keep all the latest Custom Functions right at your fingertips!

Newest Custom Functions:

1. decFromHex ( hexValue )
  (Mon, Oct 16, 12:34pm)
2. MonthYearList ( startmonth ; startyear ; numbermonth ; short )
  (Mon, Oct 16, 3:38am)
3. ErrorDescription ( errorNumber )
  (Wed, Sep 27, 2:51am)
4. decodeEntities (text)
  (Wed, Sep 27, 1:22am)
5. HexidecimalToNumber ( HexidecimalValue ; counter )
  (Mon, Sep 25, 12:39pm)
6. FixedFieldConverter ( Fieldname ; f1 ; f2 ; f3 ; f4 ; f5 ; f6 ; f7 ; f8 ; f9 ; f10 ; f11 ; f12 ; f13 ; f14 ; f15 ; f16 ; f17 ; f18 ; f1
  (Fri, Sep 15, 12:34pm)
7. ShannonEntropy ( text )
  (Thu, Sep 07, 5:59am)
8. LetterCount ( text ; summary )
  (Thu, Sep 07, 5:53am)

RSS Feed of Custom Functions