text format on export

[weezy]

Every time I export text to a csv file some of the text fields appear in all CAPS - I need them in titlecase. In the database they are appear to be correct - I've gone to the trouble of fixing each field with the TextStyleAdd() function.

When the records are imported into the database they are all in CAPS, then changed via the TextStyleAdd() of TextStyleRemove().

Why doesn't it preserve the formatting on the export?

Any ideas?

[Lee Smith]

Hi Weezy,

I think the problem lies in how the data was entered into FileMaker.

Click in the fields of offending records where you see this, and I believe you see that the data will was entered in CAPs. Even though you have the field displaying it differently (possibly), the data is in Caps.

Let us know if this is correct, and we can offer some help in getting the data correct..

HTH

Lee

Edited September 26, 2007 by Guest

[comment]

Try using Proper ( field ) instead of TextStyleAdd ( field ; Titlecase ). TextStyleAdd() merely styles the text - this is not preserved when you export plain text. Proper() modifies the actual characters.

[weezy]

Thanks! That fixed it... the proper() function that is.

[throwmethedisc]

Hello-

I am having a similar issue with exporting data to excel. My data is Proper, and I would like it to show up as CAPS for this specific export. I didn't understand where you put the Proper ( field name ) function into service. I assume there is a similar function for Caps ( field name ), but I don't know how or where to plug it in. I'm grateful for any insight!

[comment]

You need to define a calculation field and enter the formula in its formula box. The function to use in this case would be Upper(). Then you export the calculation field instead of the original.

If there are many such fields, you should look into some alternatives, such as post-processing the exported file in a text editor, or formatting in Excel itself.