If you''re creating a new report the DOS selection in Option#6 exports it exactly as you set up the report in Option#7. What you get out is a straight DOS text file. To set up a .csv file I normally just use commas but you can also use commas and quote marks as per the standard. You need to be careful that there are not commas in the text of what you're exporting. My experience is that regardless of how the convention is supposed to work, the comma in the text, even if the text is surrounded by quotes, screws things up. When I find that this is an issue I use another set of delinators (sp?) to separate fields, search and replace commas in the text, then replace the delinators. Does this help?
There is an option in the built-in reports that does much the same and you can set your own delinators there as well.
Don Friedman
Pittsburgh
On 8/31/06,
Rich Bragonje <[EMAIL PROTECTED]> wrote:
Hi folks,
I am going to be importing into an Access database, using .csv formatted
data. Choices in the import process are between Windows(ANSI), DOS or OS/2
(PC-8), or Mac.
Going to a report in DP, option # 6, Disk File Mode WP/DOS offers either WP
(4.2) format or DOS. My question is what does this DOS format match?
And possibly related, using Ctrl-C and Ctrl-V to copy and paste between
Eudora and WP loses colons (:). Is this an issue of ANSI vs. DOS? Or
something else entirely.
Rich
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
--
Don Friedman
ProfessionalRecords.Com LLC
PRS Data Systems
205 S Main Street
Pittsburgh, PA 15215
412-784-1600 - 1-800-PRS-FILE
412-784-1615 Fax
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
