our customer needs the file as a csv, the delimited is the same internally as the csv but they need the file to have a csv extension. i used the delimited command and the next line down use the rename command to change the extension and it now gives me the result i need.
~M

>Forgive my ignorance but what is a csv file then?
>Do not use "type csv" but "type delimited".
>Cetin
>
>>that does remove the top line perfectly but the file is a txt file, type csv does not work with it.
>>~M
>>
>>>>hi all,
>>>>i have what i hope is an easy one. I have a customer and i export details to a csv file for them. on the first line it lists the field names but i want to remove this, i searched the help but no joy there, is there a way to say copy to newfile9 type csv "no header" or something?
>>>>~M
>>>
>>>

copy to myfile.csv type delimited

Cetin