Hi,

I have a problem that i have been searching for a solution for, for quite a while with no luck.

I often have to import a comma seperated file in excel, change stuff in it and save it in the same format again. The file is a speciel *.kom file exported from my economics program, and i cant alter the way it exports (";" would be easier to work with than ","). The file have the following format (if i look at it in notepad etc):
"text",1,0,"2011/01/03",1,0,"6290","","text",269.32,"text"
"text, more text",2,0,"2011/01/03",2,0,"4598","","text",400.00,"text"

The problem is that if i import the file in excel, as comma seperated, and mark " as a textqualificator (i use danish excel so not sure what the correct english word is), it loses the "" marks (sp "text" becomes text) and if I do not mark " as textqualificator it will seperate text, more text into 2 delimitations, text beign one of them and more text beign the other.

So all in all my problem is that I need to import the above in excel, make changes and get excel to save or export the following:
"altered text",2,5,"2011/01/03",1,0,"6290","","altered text",269.32,"text"
"text, altered more text",6,8,"2011/01/03",2,0,"4598","","text",400.00,"altered text"

A possible workaround (which i have used so far), is using " as texqualificator while importing, and then making excel formulas that include " at the beginning and the end in those colums that need this format and then save as a *.csv file. But as i need to make this import/export very often its not really a longterm solution, as it is a lot of work for each time i have to do it.

Does anyway know of a solution for this?

Any suggestions would be highly appreciated and thanks in advance