Link to home
Start Free TrialLog in
Avatar of Rakz0r
Rakz0rFlag for United Kingdom of Great Britain and Northern Ireland

asked on

fast csv reader for asp.net

anyone know of a fast csv reader apart from  using the split method?
Avatar of nepaluz
nepaluz
Flag of United Kingdom of Great Britain and Northern Ireland image

how about FileIO.TextFieldParser, e.g
Using xr As New FileIO.TextFieldParser("YourFilePath") With {.Delimiters = {","}}
    Dim Line = xr.ReadFields()

End Using

Open in new window

Avatar of Rakz0r

ASKER

i forgot to mention that I may have some data that may contain commas! sorry.
ASKER CERTIFIED SOLUTION
Avatar of nepaluz
nepaluz
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kaufmed
i forgot to mention that I may have some data that may contain commas! sorry.
Then it should be "text-qualified," which typically means surrounding each affected field with quotes. TFP handles such fields quite easily:

xr.HasFieldsEnclosedInQuotes = True

Open in new window