How i can include a tittle line with the names of fields ? 1

[capri1966]

Hi, i have to convert a dbf file into a csv archive but the first line must have the names of every field. How i could do this file ?. Help please.
The csv file appears with the content of fields correctly but i don't know how to include a header with the names o fields.

Thanks

 

[Olaf Doschke]

Hi Capri,

USE some.dbf
copy to some.csv type csv

does that

Bye, Olaf.

Olaf Doschke Software Engineering

https://www.doschke.name

 

[Mike Lewis]

A glance at the VFP Help will tell you that the CSV format has the field names embedded:

From the Help for [tt]COPY TO ... TYPE CSV[/tt]:

Creates a comma separated value file. A CSV file has the field names as the first line in the file, and the field values in the remainder of the file are separated with commas

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[GriffMG]

Watch out for memo fields... they are not included and you did say 'every field'


Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[Olaf Doschke]

I assume capri used COPY TO DELIMITED so far, and that has the same weakness about Memos.

VFP does not handle multiline values by the norm, both in appending CSV and creating it.

If you want total control, you can look into my faq184-7770

Bye, Olaf.

Olaf Doschke Software Engineering

https://www.doschke.name

 

[Mike Lewis]

Olaf, one very small error in your code:

For the logical case ([tt]lcType = 'L'[/tt]), I think the comment should say [tt] && process logical Fields [/tt] rather than [tt] && process numeric Fields[/tt].

It doesn't affect your logic, of course.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Olaf Doschke]

That's fixed. Thanks, Mike.

I now also changed it to a function with usage code. There's still some room for improvement and adaption, like not outputting field by field, but actually there is enough caching of filesystem and drive hardware so the output is similarly fast to COPY TO or EXPORT.

Bye, Olaf.

Olaf Doschke Software Engineering

https://www.doschke.name