exporting to csv without ""'s

[nowayback]

Hi everyone,

I want to export some data from my db in FMP 5.5 to a CSV-file.

I've created a calculated field (result is text) that contains all the data that should be in the CSV-file, but if i export the records and open the CSV-file the data is surrounded with ""'s (quotes). The program that imports the CSV-file doesn't appreciate these ""'s.

How can i prevent the ""-adding ???

[Steven H. Blackwell]

If you don't want the quotes, then don't use CSV. Quotes are an integral part of CSV. Use tab delimited instead. An aletrnative would be first to open the CSV export in a text editior or word processor and replace the quote marks.

HTH

Old Advance Man

[nowayback]

The problem is, the machine can only import an CSV-file; if i export the data as a tab delimited file, the machine can't read it.

If i have to open the export file in a Word editor and remove the quotes, then it has no use to integrate filemaker in the process.

Is there no other way?

[danjacoby]

The quotation marks are added in order to avoid the confusion that would result from having commas in the fields. Unless you can be absolutely certain that there will never be a comma in any exported text field...

[nowayback]

I'm absolutely certain that there will never be a comma in any exported text field !!

GreetZ

[The Bridge]

Depending on the length of the fields you're exporting, you could try this:

Define a calculation field: Data_Export, result is text.

= Field1 & "," & Field2 & "," & Field3 & ",".... Fieldn & "