exporting without quotation marks

[emerywang]

Hi. Anybody know how to get Filemaker to not add in the quotation marks

when files are exported?

For example, what should be 1,2,3 ends up being "1","2","3"

This happens when I export as comma separated text. I can't use another option, however, since the program I want to use this text file in requires comma separated text.

Thanks!

-Emery

[LiveOak]

You will probably have to export with the quotes and post process the file to remove them or export as tab delimited and replace the tabs with commas. Quotes are a part of the definition of the CSV file format. Without quotes, there is no way to deal with imbeded commas. What you are asking is kind of like "let's use decimal numbers but remove the zeros", you are not left with a consistent system. Will your import processor accept any other formats? What are you importing into?

-bd

[CobaltSky]

It is possible to achieve what you want using a plug-in. There are a number that will do the job, but a couple of examples are Troi File (from Troi Automatisering) and File Toolbox (freeware from Protolight).

If you're interested, URLs for the above examples are:

Troi File:

http://www.troi.com/software/fileplugin.html

Protolight:

http://www.protolight.com/plPLUGs.html

Alternatively, check out the plug-in directory on the FileMaker site for other examples.

[BobWeaver]

You can combine the fields you want to export into a single calculated field like this:

Field1 & "," & Field2 & "," & Field3

Then export this single field as tab delimited.