|
Have you taken a look at the contents of this article[^]? It seems pretty comprehensive.
This space for rent
|
|
|
|
|
For C#, I'd use A Fast CSV Reader[^] which handles all of that, and more besides.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
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
|
|
|
|
|
Thank you so much for all the fast responses.
While i will try the solution provided, is there a way to overcome the issue without using third party solution?
Thanks!!
|
|
|
|
|
Yeah, write the code yourself.
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.
|
|
|
|
|
Thank you - I did try the Flat File connection, specifying the delimiter.
The file has comments field, which is freeform. The is data like below, which is causing the Flat file load to fail --
,"This is a test with more "testing" and tests"
|
|
|
|
|
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.
Patrice
“Everything should be made as simple as possible, but no simpler.” Albert Einstein
|
|
|
|
|
ppolymorphe wrote: When I generate a CSV file, I use a Tab (chr 9) as a column separator
Technically, it's not a "CSV" file then.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Richard Deeming wrote: Technically, it's not a "CSV" file then. Agreed, but this variant is way practical
I am used to languages that have sophisticated packages to support this kind of things, and the Tab trick really simplify things.
Patrice
“Everything should be made as simple as possible, but no simpler.” Albert Einstein
|
|
|
|
|
Use the TextFieldParser class from the Microsoft.VisualBasic.FileIO namespace; e.g.
using ( TextFieldParser parser = new TextFieldParser( fileName ) ) {
parser.HasFieldsEnclosedInQuotes = true;
parser.SetDelimiters( "," );
while ( !parser.EndOfData ) {
string[] fields = parser.ReadFields();
}
}
|
|
|
|
|
Hi Friends,
What is the best approach to fill the employee details to predefined templates and suggest the template fornat for printing the id cards for web application.
Thanks in advance ..
Regards
Girish
|
|
|
|
|
This is not a programming issue. The design and content of such a card will depend on what you wish to use them for.
|
|
|
|
|
Thanks for replying Richard.
The design will be like employee Identity card for organization.
and contents like Employee image, company logo and other employee details like name, address etc.
|
|
|
|
|
The best way is by defining what information you have on the card, and then to implement a strategy to fetch those details.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Univote countered.
This space for rent
|
|
|
|
|
Downvote countered.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
|
Hello,
I have a requirement of odbc connection method in Microsoft.Practices.EnterpriseLibrary.Data assembly(version 5). Whether it is available in Microsoft.Practices.EnterpriseLibrary ?
Or it there any suitable alternatives for ODBC in Microsoft.Practices.EnterpriseLibrary ?
Please help me.
|
|
|
|
|
|
I want to connect Microsoft Access using Microsoft.Practices.EnterpriseLibrary, for that I need ODBC method.
|
|
|
|
|
Using the Data Access Application Block with Access is a bit like using one of those automated skyscraper construction platforms (image[^]) to build a hut
If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson
|
|
|
|
|
srikrishnathanthri wrote: for that I need ODBC method No you don't. You can use an OleDb connection to connect to Microsoft Access and that's supported by the DAAB.
This space for rent
|
|
|
|
|
Pete O'Hanlon wrote: No you don't. You can use an OleDb connection
but we have migrated from OleDb to ODBC, so we cant go back to OleDb.
Is there any other ways for me.?
|
|
|
|
|
ODBC can be achieved by GenericDatabase Class of Microsoft.Practices.EnterpriseLibrary.Data
Thank you all for your replies.
|
|
|
|