Re: Parse CSV file with two delimiters - C# Discussion Boards

Parse CSV file with two delimiters

20-Jun-16 4:51

Have a look at the DirectoryInfo[^] class.

This space for rent

VK1920-Jun-16 2:41

VK19

20-Jun-16 2:41

Hello,

I am trying to parse a CSV file having two delimiters, first one is a comma(,) second one is a double quote("). So string related looks like "First", "Last", "123 main st",.
Decimals and time is like 120.00, 01/01/2016 1:44:23 PM,.

The issue is when there is a comma in the string field. Like -- "First", "Last", "123 main st","Apple, Inc.","San Francisco".

Initially I tried to load the CSV file using SSIS Package, there is a comments field, which users are to enter comments, as a result the file has data with double quotes in the comments. The package load failed as a result.

Any ideas is much appreacited.

Thanks!

Pete O'Hanlon20-Jun-16 2:53

20-Jun-16 2:53

Have you taken a look at the contents of this article[^]? It seems pretty comprehensive.

This space for rent

OriginalGriff20-Jun-16 2:53

OriginalGriff

20-Jun-16 2:53

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...

Sascha Lefèvre20-Jun-16 2:56

Sascha Lefèvre

20-Jun-16 2:56

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

VK1920-Jun-16 3:20

VK19

20-Jun-16 3:20

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!!

Dave Kreskowiak20-Jun-16 3:57

Dave Kreskowiak

20-Jun-16 3:57

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.

A guide to posting questions on CodeProject

Click this: Asking questions is a skill.
Seriously, do it.

Dave Kreskowiak

PIEBALDconsult20-Jun-16 3:28

PIEBALDconsult

20-Jun-16 3:28

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.

VK1920-Jun-16 3:31

VK19

20-Jun-16 3:31

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"

Patrice T20-Jun-16 6:43

Patrice T

20-Jun-16 6:43

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

Richard Deeming20-Jun-16 6:52

Richard Deeming

20-Jun-16 6:52

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. Smile | :)

"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

Patrice T20-Jun-16 6:58

Patrice T

20-Jun-16 6:58

Richard Deeming wrote:
Technically, it's not a "CSV" file then.

Agreed, but this variant is way practical Blush | :O

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

Gerry Schmitz20-Jun-16 16:47

Gerry Schmitz

20-Jun-16 16:47

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();
     // etc.

  }  // end while.

}  // end using.

Template for Id Cards

suregirish19-Jun-16 23:35

suregirish

19-Jun-16 23:35

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

Richard MacCutchan19-Jun-16 23:57

Richard MacCutchan

19-Jun-16 23:57

This is not a programming issue. The design and content of such a card will depend on what you wish to use them for.

suregirish20-Jun-16 0:07

suregirish

20-Jun-16 0:07

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.

Eddy Vluggen20-Jun-16 1:39

Eddy Vluggen

20-Jun-16 1:39

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 Suspicious | :suss:

If you can't read my code, try converting it here[^]

Pete O'Hanlon20-Jun-16 2:47

20-Jun-16 2:47

Univote countered.

This space for rent

OriginalGriff20-Jun-16 2:51

OriginalGriff

20-Jun-16 2:51

Downvote countered.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

ODBC method in Microsoft.Practices.EnterpriseLibrary.Data

Richard MacCutchan20-Jun-16 3:52

Richard MacCutchan

20-Jun-16 3:52

I suggest you read How to get an answer to your question - C# Discussion Boards[^].

srikrishnathanthri19-Jun-16 18:41

srikrishnathanthri

19-Jun-16 18:41

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.

Re: ODBC method in Microsoft.Practices.EnterpriseLibrary.Data

Richard MacCutchan19-Jun-16 21:35

Richard MacCutchan

19-Jun-16 21:35

Not sure exactly what you want, but I would suggest checking at Enterprise Library 5.0 – May 2011[^].

Re: ODBC method in Microsoft.Practices.EnterpriseLibrary.Data

srikrishnathanthri19-Jun-16 21:59

srikrishnathanthri

19-Jun-16 21:59

I want to connect Microsoft Access using Microsoft.Practices.EnterpriseLibrary, for that I need ODBC method.

Re: ODBC method in Microsoft.Practices.EnterpriseLibrary.Data

Sascha Lefèvre20-Jun-16 0:06

Sascha Lefèvre

20-Jun-16 0:06

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 Wink | ;)

If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

Re: ODBC method in Microsoft.Practices.EnterpriseLibrary.Data

Pete O'Hanlon20-Jun-16 0:42