textstyle-add and export

[macavity]

Hi,

I've used Textstyleadd in FM12 to change names entered in all caps into title case. However exporting them as csv seems to read the original ASCII. I have not been able to find a way to export csv with the corrected title case spelling. Is it possible?

Thank you for any suggestions.

[comment]

I have not been able to find a way to export csv with the corrected title case spelling. Is it possible?

​No, it is not. CSV is a plain text format and any styles you may have applied to the text are not included. You need to use the Proper() function instead of TextStyleAdd(), if you want it to export that way. Note that this will actually modify your data and there will be no way to revert back to the original. If this is for export only, there are other ways (e.g. use a calculation field).

Edited April 24, 2015 by comment

[macavity]

Thank you so much, comment! I hadn't known that the Proper function actually changed the spelling. The names were imported from a French database where capitalising last names is common. We want them changed throughout the database, so the Proper solution is ... the proper solution. Thanks again!

[comment]

Just keep in mind that applying Proper or TitleCase to last names does not always produce a "proper' result. For example, "D'ARTAGNAN" will be converted to "D'artagnan" instead of the original and proper "d'Artagnan".