A tiny question about .CSV files

[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

 

[Danny]

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

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.

 

[JE McGimpsey]

Look here:

http://www.mcgimpsey.com/excel/textfiles.html#csvwithquotes

 

[Adas Miauczynski]

or if not, I would write sometihng that will put the commas around each

field such as:
""""&A1&"""" for example.

Thanks a lot!!

___
AM