Text String extraction

[#1]

Dear Community,

I have a text string that is rather large - it captures all activity associated to one company. It does however have some rules set against it.

I am trying to find the text associated with "Meeting 1" which can occur at any point in the string. It will be captured as:

[Date Time] Name - Meeting 1 - blah blah blah

[Date Time] Name - Another activity - blah blah blah

What i would like to do is capture the "blah blah blah" in a sepertate text box & then, if possible, capture the next meeting in another box (the second occurance of "Meeting 1")

I've tried:

mid(TEXT FIELD, findoneof(TEXT FIELD, 'Meeting 1')) as a start but this isn't working correctly.

I need to find the text after "Meeting 1" and before the next "["

Many thanks

Drew

[Anonymous]

This works fine in a text box:

=trim(TextBetween('any text Meeting 1 text to select [ more of any text','Meeting 1','['))

(I added trim() to remove leading and trailing spaces)