Subject Re: separator for CSV file to be imported into dBase
From Akshat Kapoor <>
Date Thu, 24 Sep 2020 15:49:16 +0530
Newsgroups dbase.getting-started

Good Evening Mervyn,

> I'm afraid changing the separator from ; to , and wrapping each field in
> double quotes in the .csv file is not appropriate in this case.
> Character fields only really need to be delimited if they contain
> commas.  In this case though the comma in a field is actually the
> decimal point of a numeric value.
> Wrapping a numeric value in double quotes in a .csv file confuses dBASE.
>   In the attached screenshot the first two records were created by the
> little program I posted yesterday.  The second two records were created
> by appending from the output.csv file that you provided.

Without exact table structure such codes are difficult to design but you
have utilised breakstring() wonderfully. I would have reinvented the
wheel for breaking the string

> A table with 500 fields is unusual (and unwieldy :-) ) but dBASE can
> handle up to 1024 fields in a record with a limitation of 32767 bytes
> per record.

dBase can handle 1024 fields BUT I doubt that the hairs on the
programmers head will be able to bear that much load.

I would be pulling my hairs out if I was the programmer. A Single
missing , " etc would be damn difficult to trace.