Leaderboard

But then this contradicts your earlier statement: Here, the first character after the full stop and space is a carriage return. So this is still not as "simple" as promised. So far I've come up with this = While ( [ listOfValues = Substitute ( YourTable::Textfield ; [ ". ¶" ; Char (1300031) ] ; [ ". " ; Char (1300030) ] ) ; i = 1 ; n = ValueCount ( listOfValues ) ; result = "" ] ; i ≤ n ; [ value = GetValue ( listOfValues ; i ) ; result = List ( result ; Upper ( Left ( value ; 1 ) ) & Right ( value ; Length ( value ) - 1 ) ) ; i = i + 1 ] ; Substitute ( result ; [ Char (1300030) ; ". " ] ; [ Char (1300031) ; ". ¶" ] ) ) See if it works for you as expected. I'll try to come back to this later to see if it can be streamlined a bit. Is there ever a case where a carriage return comes in the middle of a sentence?

That is indeed simple. Perhaps even too simple - because that would exclude the very first letter in the field. Assuming that's not what you meant, and assuming a bunch of other stuff - such as that the first character after a full stop and a space is not a punctuation character, and that the field does not contain any carriage returns - you could try something like = While ( [ listOfValues = Substitute ( YourTable::Textfield ; ". " ; "¶" ) ; i = 1 ; n = ValueCount ( listOfValues ) ; result = "" ] ; i ≤ n ; [ value = GetValue ( listOfValues ; i ) ; result = List ( result ; Upper ( Left ( value ; 1 ) ) & Right ( value ; Length ( value ) - 1 ) ) ; i = i + 1 ] ; Substitute ( result ; ¶ ; ". " ) )

Be aware that files store as references is a feature that is on the Deprecation list. https://support.claris.com/s/answerview?anum=000025819&language=en_US