Geeks With Blogs
rusty "Razorblade" coslett stainless musings
Searched all over the net to NOT have to write another CSV Parser.  I want to just say 'go do it now, no complaining just go'.  I was happy to have found somewhere along my search the Microsoft.VisualBasic.FileIO.TextFieldParser.

Works great for what I needed with no worries about line length, terminators, etc.  I also did not have embedded commas in my file.


   Private Sub walkTheCSV(ByVal fileName As String)


        If (String.IsNullOrEmpty(fileName)) Then


        End If


        ' check if it exists, etc.


        Using tp As New TextFieldParser(fileName)


            tp.TextFieldType = FileIO.FieldType.Delimited



            Dim currentRow As String()

            While Not tp.EndOfData



                    currentRow = tp.ReadFields()


                    For Each currentField As String In currentRow


                        If (String.IsNullOrEmpty(currentField)) Then

                            Continue For ' do not care to process an empty field

                        End If




                Catch ex As MalformedLineException

                    ' eat it or move on...

                End Try


            End While


        End Using


    End Sub


Posted on Wednesday, April 22, 2009 2:53 PM 4 Posterity | Back to top

Related Posts on Geeks With Blogs Matching Categories

Comments on this post: CSV Parsing No More: TextFieldParser

# re: CSV Parsing No More: TextFieldParser
Requesting Gravatar...
Thanks for posting this!
Left by Josh on Apr 22, 2009 5:10 PM

# re: CSV Parsing No More: TextFieldParser
Requesting Gravatar...
Hope it helped, I am tired of writing so much plumbing code.

Left by rusty on Apr 27, 2009 1:31 PM

Your comment:
 (will show your gravatar)

Copyright © rusty | Powered by: