Manipulating text inside a paragraph

[Oldsneekers]

I

[comment]

Hint: count the periods in the part that ends with "Category".

[BobWeaver]

Also the Position function has a start parameter which allows you to ignore all occurrences prior to the one you want. So:

SentenceStart= Position(ParagraphText;"Category";1;1)

SentenceEnd=Position(ParagraphText;"."; SentenceStart;1)

SentenceText=Middle(ParagraphText; SentenceStart; SentenceEnd-SentenceStart+1)