CSV files

[TKnTexas]

I have been working on a using Filemaker Pro to act as a filter application. There are four text files generated when we run AP reports.

We have some Access data applications that use the filtered data. The main one imports a CSV file that represents all of the invoices that were entered to the AP system. It is prior to posting.

We are checking for dupes. Dupes within the imported data, and dupes against the historic data (back to 2008). The output is the matching data (if found). We are primarily looking for invoices posted once to a wrong vendor, then a second time to the correct vendor.

My calculations parsed out the data, and created a CSV file for the Access database to import. There are double quotes around all of the data, in each field. I deliberately put a dupe invoice into the file. The report showed no dupes. How do I get the file without the double quotes, or can I?

I cannot make any changes to the Access database. It's programming is looking for a specifically named file that is in CSV format.

[TheTominator]

My calculations parsed out the data, and created a CSV file for the Access database to import. There are double quotes around all of the data, in each field. [] The report showed no dupes. How do I get the file without the double quotes, or can I?

Quotes around each field is part of the CSV format. You cannot get the CSV export file without double quotes without post-processing it in a different program.

Note that the quotes allow you to have a comma in the data field. Without the quotes, the comma would be interpreted as a field separator.

If you want tighter control of the output, use XML and a custom XSLT stylesheet. You can get something CSV-like pretty easily.

[TheTominator]

Are you sure you need to remove the quotes in the CSV file?

Access should be able to deal with them properly. A quick Google search tells me that you need to specify the "Text Qualifier" as a double quote when importing.