EXPORTING .CSV WITH FIELD NAMES

[KMdouglas]

I am trying to export a table to a csv file with header names. I have one field which is named "FILE #" When I export to csv (or Excel for that matter) the name of that field is changed to "FILE ." Does anyone know why this happens, and what I can do to have the field name appear as it should "FILE #"

Any help would be greatly appreciated

Kevin M. Douglas
kevin@easternresearch.com

http://www.easternresearch.com

 

[Databaseguy]

Well, I can't explain why. But, as a general rule, one should refrain from using non alpha numeric characters when naming objects. Specifically for the reason you're encountering now.

This applies, although to a lesser extent, to data also. Imagine, for example, searching for the character * in a field. It can be done, but it demonstrates potential pitfalls.

To answer your question specifically, I would suggest changing the field name to File_Num. Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy