reading comma delimited files using VB.NET

[Guest]

How do you read comma delimited data from programs such as Excel where the
data itself contains dounble quotes and commas. It used to be you could just
use input. How is it fone now?

The data below contains output from Access saved as a CSV.
line 1,"normal data","a double quote "" here"
line 2,"a comma , here ","more normal data"

Input's help documents the "" will not work.

 

[Robbe Morris [C# MVP]]

You would use a StreamReader to read the file line by line.
Then perform a .Split(@"\",\"") on the string.

--
2004 and 2005 Microsoft MVP C#
Robbe Morris
http://www.masterado.net

Earn $$$ money answering .NET Framework
messageboard posts at EggHeadCafe.com.
http://www.eggheadcafe.com/forums/merit.asp

 

[shriop]

Try my parser, http://www.geocities.com/shriop/index.html

 

[Cor Ligthert]

Ron,

Normally is used OleDb for that creating a dataset.

This is one of the messages where I have a sample about that.

http://groups-beta.google.com/group/microsoft.public.dotnet.languages.vb/msg/40e1d7736d7f2a02

I hope this helps,

Cor

 

[Guest]

Robbe,

As I understand the split function wouldn't that split on every "?

For example "7 inches""" would return 7 inches and "" and not 7 inches"

Thanks,
Ron