GetTextMiddle ( text ; string1 ; string2 )

This gets the text from the middle of a field, variable, or text, starting at a single char 'string1' up to a single char 'string2' (element/delimiter).

Be the first to rate this function Log in to vote

Royce White - Show more from this author
The Caris Group

Sample input:

GetTextMiddle(text; ":"; "@") where text = "Invitation: Doctor Visit @ Fri Mar 27, 2026 1pm - 2pm (EDT) (Morris Magillicutti)

Sample output:

"Doctor Visit"

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

//Royce White, created 20260226, 1645; Updated 20260227, 1137.

// This gets the text from the middle of a field reading between two strings (or delimiters). For instance if a field has the following:
// text  = "Choose a Topic: Math for the day or other amazing things @ The Museum of Natural Math"
// GetTextMiddle(text; ":" ; "@") would yield "Math for the day or other amazing things"

// or use the following to scrape the subject from a Google Calendar event invitation email on IOS using Shortcuts and then parse -
// text  = "Invitation: Doctor Visit @ Fri Mar 27, 2026 1pm - 2pm (EDT) (Morris Magillicutti)
// GetTextMiddle(text; ":" ; "@") would yield "Doctor Visit"



Middle (
          text ;
          Position ( text ; string1 ; 1 ; 1 ) + Length ( string1 ) ;
          Position ( text ; string2 ; Position ( text ; string1 ; 1 ; 1 ) + Length ( string1 ) ; 1 ) - ( Position ( text ; string1 ; 1 ; 1 ) + Length ( string1 ) ) 
      )



// See also GetText() and GetTextRight()  [not necessary to run THIS script]

I originally set this up in a script that is receiving the Subject line [ Get(ScriptParameter) ] from 'Shortcuts' (IOS) emails with the different Google Calendar Invitation email words. The Script parses the word(s) used in different Google emails ('Invitation:' or 'Updated Invitation:' or Canceled Event:" – from the Subject and runs subscripts to parse out info and insert/delete/change it correctly in my personal Scheduler (in FM made decades ago). [I also have it adding to my Chores section when my wife sends me an email (or Message) where the first line of the subject line is 'Chore:' The three different CFs – GetText(), GetTextMiddle(), and GetTextRight() are used to parse out more easily, the different things from the Subject line – or anywhere. As long as you have some kind of element you can use to start and stop. You can modify to have it pull different 'occurrences' of the 'element' you use in 'string' as well as other mods. You can also use with GetValue() in a WHILE or LOOP to grab reoccurring data in a list. It's nothing special but it saves me time. Enjoy!

Comments

		Royce White, The Caris Group Feb 27, 2026
Updated 20260227, 1137, to accept any size string not just a single character.

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

GetTextMiddle ( text ; string1 ; string2 )

Comments

Support this website.

Support this website.