Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 07/26/2021 in all areas

  1. 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?
    1 point
  2. 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 ; ¶ ; ". " ) )
    1 point
  3. 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
    1 point
This leaderboard is set to Los Angeles/GMT-07:00
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.