Shorten Text

[orgreeno]

Hello, I'm new to filemaker so this may be an easy question. I can't figure out how to shorten a text field to two sentences. I'm assuming that some how I can split on the second period. Thanks in advance.

[Genx]

Hi Orgreeno and welcome to the Forums!!

You can really do this a few ways... the first two I thought of are below:

1) This one came to mind first for some reason though its a bit roundabout, I seem to like substitute and arrays for some odd reason...

Substitute( MiddleValues( Substitute( "I am a sentance. Me To. And me." ; "." ; ".¶" ) ; 1 ; 2 ) ; ¶ ; "" )

2) This one will probably please more people and is slightly more efficient.

Let( sentance = "I am a sentance. Me To. And me.";

Case( PatternCount( sentance ; "." ) > 1 ; Left( sentance ; Position( sentance ; "." ; 1 ; 2 ) ) ; Sentance )

)

Hope that helps.