|Wizard-Fred. Sorry, I don't understand the need for double quotes. The original file supplied by the OP doesn't appear to contain any single or multiple csv fields within double quotes so I didn't include any. |
I understood that double quotes were intended to allow grouping multiple csv under one header, such as an address e.g. ...,"26 First Ave,Wilmington,Del,34567",... so that they can be extracted as one but my experience in manipulating a db is limited.
The script, after minor mods, can enclose all or individual fields in double quotes.
>>output.csv echo "%%1,%%2,%%3,%%4%%5,%%6"
would enclose the entire line in quotes whereas
>>output.csv echo "%%1","%%2",%%3,%%4%%5,"%%6"
would enclose the first, second and final field in quotes.
Your further advice appreciated although I dislike hijacking Certteam's thread.