column names

[LVA]

I use windows 2000 and filemaker 5.5

I would like to know if someone knows how do I export records from filemaker to a txt file (this txt file could be excel, for example) and I would like to choose the columns names.

For example: I have a filemaker file with vehicle data. The fields I would like to export are called: VIN, date, _c24closed, _c48closed, _cOpen

When I export records from these fields and when I open using excel the column names are the same as in filemaker. The problem is that I would like to change the column name the the TXT file. Does someone know how to do it using filemaker , or is there a plug-in I could use to change the column name when exporting the records ?

[Lee Smith]

I'm not sure I followed what you are trying to do. If this isn't wat you want, maybe a little different approach to the question would be in order.

If you use the merge format for exporting a file, the field names will also be exported.

HTH

Lee

[cjaeger]

I make this as follows:

- export format: tab text

- found records are sorted by serial number

fist I do a (scripted) find

now I add a record by script. serial number -1 (or 0)

Each collumn of this record will be set to eport field name by script

sort by serial number

export records

delete first record (with serial number -1 [or 0] )

[cjaeger]

I make this as follows:

- export format: tab text

- found records are sorted by serial number

fist I do a (scripted) find

now I add a record by script. serial number -1

Each collumn of this record will be set to eport field name by script

sort by serial number

export records

delete first record (with serial number -1)

[LVA]

Lee Smith ,

Thanks.

I would like to export the records and the field names, but not the names as they are but instead of the names in filemaker I would like to change them while exporting. The names in filemaker are good for programmers to understand. The TXT files are going to be sent to some users and the names aren't so good for their understanding.

[Lee Smith]

Well, that was the way I understood it the first time, but It make a little more sense when I read the two of them.

You could do this in a couple of ways.

1). Create a second database for import/export where you can match the current database names up with the new field names and then export that as a merge file, or

2) Create a second field for each existing field you will be exporting and use those for your export as a merge file. BTW, you can populate these new fields with your existing data by using calculations, or a looping script.

Does that make sense to you.

HTH

Lee