Jump to content

exporting to csv without ""'s


nowayback
 Share

This topic is 7203 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 ???

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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? crazy.gif" border="0

Link to comment
Share on other sites

This topic is 7203 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Who Viewed the Topic

    1 member has viewed this topic:
    Milefaker2 
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.