Jump to content

textstyle-add and export


macavity
 Share

This topic is 2778 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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 by comment
Link to comment
Share on other sites

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!

Link to comment
Share on other sites

This topic is 2778 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

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