Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CSV with double quotes
Message
From
09/03/2017 06:10:20
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01648804
Message ID:
01648874
Views:
52
>This gets rid of the dang double quote problem....
>
>COPY to myfile.csv delimited with "" with character '|'
>
>...if you do that command it creates a file without those stupid quote marks, delimited with the pipe symbol.
>
>...Sorry I was late to the game here I didn't notice the thread till just now - but perhaps this can help you out now or in the future. This is one quirk that got me stuck in the past.

Victor,
I couldn't understand how this would solve the problem. Wouldn't it be a new and more serious problem in itself? If for a second you think it could work, what would happen to a field that contains | ? Or a field with comma, apostrophe, tilde ... in it? Or one with date time data? I would repeat my warning that trying to transfer data to Excel using text is asking for trouble (unless that text is a well known data interchange format, say, XML).
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform