A tiny question about .CSV files

A

Adas Miauczynski

Hi everybody,

I'm trying to upload my adress book to a web page that accepts .csv files.
The file I have looks something like this: SomeData;SomeData;
but the server I'm trying to upload it to wants me to give him data in
quotation marks. So my file should look like: "SomeData";"SomeData";
How can I add those quotation marks to all the entries?

Thanks in advance
 
D

Danny

Adas Miauczynski said:
Hi everybody,

I'm trying to upload my adress book to a web page that accepts .csv files.
The file I have looks something like this: SomeData;SomeData;
but the server I'm trying to upload it to wants me to give him data in
quotation marks. So my file should look like: "SomeData";"SomeData";
How can I add those quotation marks to all the entries?

Thanks in advance
Click to expand...

You can use ms Access to do the export, it lets you specify any delimiter
you like and also to put quotes around each field.

or if not, I would write sometihng that will put the commas around each
field such as:
""""&A1&"""" for example.
 
Top