dbTalk Databases Forums  

CSV Export

comp.databases.filemaker comp.databases.filemaker


Discuss CSV Export in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Doug Anderson
 
Posts: n/a

Default CSV Export - 04-17-2007 , 11:27 AM






Is there a way to export data from FileMaker as a CSV without having
the field values bracketed by quotes? I need to export data daily for
an upload to another system. That system requires CSV files, but it
will not accept quoted fields.

To get by I export to Excel from FM, then use Excel's Save As to CSV to
get the file I need. I would just prefer to avoid the Excel step.


Reply With Quote
  #2  
Old   
Tom Stiller
 
Posts: n/a

Default Re: CSV Export - 04-17-2007 , 12:59 PM






In article <2007041711273916807-dougcpa@gmailcom>,
Doug Anderson <dougcpa (AT) gmail (DOT) com> wrote:

Quote:
Is there a way to export data from FileMaker as a CSV without having
the field values bracketed by quotes? I need to export data daily for
an upload to another system. That system requires CSV files, but it
will not accept quoted fields.

To get by I export to Excel from FM, then use Excel's Save As to CSV to
get the file I need. I would just prefer to avoid the Excel step.
If you're not opposed to using a Terminal command, you could export the
data as tab delimited and then issue

tr "\t" "," < Filemaker_export > Forign_file_import

to translate all tab characters to commas.

--
Tom Stiller

PGP fingerprint = 5108 DDB2 9761 EDE5 E7E3
7BDA 71ED 6496 99C0 C7CF


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.