TextStyleAdd( TextFormatRemove (self) ; Titlecase) and Proper ( TextFormatRemove (self) )
produce identical results so there is no advantage/disadvantage to either.
What you describe could be accomplished with a recursive custom function that loops through the text one word at a time and assigns a text format to each individual word as it does so. This requires FileMaker Advanced to do so and is unlikely to be perfect in its results. Consider such things as the different ways a surname like MacDonald can be capitalized.
Exact ( text ; upper ( text ) ) can detect if text is all upper case and Exact ( text ; lower ( text ) ) can detect if text is all lower case. This gives you the option of applying titlecase only if text is all caps or no caps.
Hello guys,Excuse me but, if you permit, i would like to add some comments about all this :1 )TextStyleAdd( TextFormatRemove ( self ) ; Titlecase ) and Proper ( TextFormatRemove ( self ) )produce identical results so there is no advantage/disadvantage to either.Not exactly : as you know, it proceed at different levels (Data and Formatting are not the same). So the differences between them will be context-depending. For instance :• When you remove the text style (for instance with a copy paste or with Format Menu)• When you export your data• When you re-proceed the data in another calculation (for instance to use Upper, that will "seem" fail, if some data is formatted lowercase)2 ) If i understand correctly the sense of original post, it could be named like this :Using TextStyleAdd ( Text ; TitleCase ) or Proper ( Text ) ?
For the rest, Big Up Phil, for the end tip you provided : great mind !
PS : Sorry to come here even the Post is checked OK. But i would initially create a new post to help a friend and i found this that appear almost perfect...