I need to import a large CSV file (exported from win 2000 MSSQL-server), which contains of fields like this.
"this is the title","And this is a lot
<b>This should be in bold</b>
And the text ends here for this entry","334"
"title number 2","and this title also has
linebrakes in it...
<i>which is causing me</i>a headache,"897"
I need to get this into Excel, with each data field in one column. But it seems that if there are linebrakes in the file, it all gets messed up - and the . I thought that was the reason why you can configure Excel to use the double quotation character as a text delimiter during import, but that doesn't help when it comes to the linebrakes.
I've been testing all different types of delimiters, using comma,tab, semicolon - and single and double quotation marks as text delimiters. But nothing works so far...
How do I go about this?
The reason I need to set this up like this in Excel, is because I need to add some data to each entry. Therefore I thought it would be simplest to import it into delimited columns, and then just add the new columns - and export it again as a new csv-file.
So if you happen to know a way how to add for example the data field: "additional data" between "title" and "text" in the whole document (without the need of using columns in the first place), then that would solve my problem to!