Exporting Text Not Holding Text Format

[Papabjoe]

I'm having a problem with the data text format. I have this database in which the raw data has all been entered in lower-case type. In filemaker I have set the field to display the type in "title-case". However, my mailing service is requireing an excel file. When I export the data as a comma or tab delimeted file i select the option to format the text according to the layout format. However, when I bring the data into excell, it is all lower-case. Does anyone have any suggestions?

[-Queue-]

The formatting based on current layout option applies to numbers, times, and dates only. You will have to run a Set Field loop or Replace Field Contents with Proper(yourfield) to change the text for exporting.

[Papabjoe]

Can you give me an example?

[-Queue-]

Freeze Window

Show All Records

Go to Record/Request/Page [First]

Loop

Set Field [yourfield; Proper(yourfield)]

Go to Record/Request/Page [Next; Exit after last]

End Loop