The double quotes are no delimiters in the same sense as the column delimiter - they're used to quote strings in order to allow occurrences of the actual delimiter within a string as part of the string. If a CSV-reading code can't deal with that then it's because it's not paying attention to whether a delimiter is within a quoted string or not.
There are several solutions for reading CSV, here's a great one (which will have no trouble with this): A Fast CSV Reader[^]
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
The problem is you're making a trade off. You're giving up the convenience of having a pre-made solution that works for one where you're going to spend a lot of time writing code and testing it, and fixing bugs, and testing it, and testing it some more.
I know of two ways to load CSV with SSIS.
The first way is with an OleDB connection (and the ACE engine), but it doesn't work very well.
The second way is with a Flat File Connection, which works much better and allows you to specify quotes.
Using columns separator that can apear in column data is a bad idea because it complicate reading and it is possible to do otherwise. It become very tricky when a column can contain both column separator and string delimiter, in this case you almost need to write a program dedicated to reading this particular file.
When I generate a CSV file, I use a Tab (chr 9) as a column separator and no " around strings. Since the Tab is only used as column separator, reading is really easy because of the unique usage of the tab.
“Everything should be made as simple as possible, but no simpler.” Albert Einstein
I develop an Skype Tool, who will be very usefull for many people.
But now, I check the option to send an message for all the
Conversation in the skype account, but I haven't found any result!
So, I went over to this Forum to get some help, and to ask
if is it possible to send an message for all your conversation?
Thanks for all!
I'm sorry but I have had serious problems trying to decode the question you are asking here. Are you wanting to provide a mechanism to send a message to all the people a user is connected to via Skype?
This space for rent
Last Visit: 31-Dec-99 18:00 Last Update: 30-Jun-22 13:38