Thread: Reading a .CSV file

I checked, each line in the CSV file does end with a comma. Latest issue - application is reading CSV file but only first line.  Not sure how to get it to move to the next line and continue until it reaches the end of the file. Clarification - App reads first line over and over again.  It seems to be stuck in the "While" loop without moving to the next line of data.  Total value increases as line 1 is added to previous...

LOL.. Gal, it's been a long time :)  The IsNot operator was introduced in 2005 as well, so you need to do the tests the old way like this: Option Strict On Option Explicit On Imports System Imports System.IO Module Module1 Sub Main() Dim total As Decimal = 0 Dim reader As StreamReader Try reader = New StreamReader( "demo.csv" ) Dim line As String = reader.ReadLine() While Not line Is Nothing Dim fields() As String =...

Try Finally End Try  ?

Don't try most of the answers in VB2003.  Most forum responders think in VB8,9 and later.  Look in your help for how to read and write text files in Visual Basic. Oh my! Yes, this is an important detail many of us overlooked. 2003 was a long time ago :) I think the way I used to do it was using streamreader.readline() and string.split()

http://msdn.microsoft.com/en-us/library/bb882644.aspx You might look at that link too for a linq example.

using TextFieldParser, and parsing each line into an array, the 10th column will be item 9 in the array. The string to double just means you have to use something like CDbl to convert the string from the file - but only use it if you are sure the data is valid. If not, use Double.TryParse. Dim filename As String = "C:\Documents and Settings\AVILAJ\Desktop\Test Folder\GAMinTN.csv" Private Sub Button1_Click( ByVal sender As...

Hi George, With the example CSV file I tried the following. Add 1 Button to a FORM to try this code please. This code should be okay for VB.Net 2003, from what I remember. Please read the code comments and change the Dim CsvFilePath As String = "C:\Tmp\" '<< Don't forget the "\" at the end!! and Dim CsvFileName As String = "Demo.csv" as appropriate. :-) Regards,...

Dim Total As Double   Dim lcStringArray() As String = "11/4/2009 1:57:50 PM,fg5,1234,21.00,21,0,0,0,0,21.00,12345".Split(",")   Dim total1 As Double = lcStringArray(9)   Total = Total + Total1

You can still use data access methods but if you plan on supporting 64-bit in the near future I would recommend the file I/O methods mentioned. Dim ConnectionString As String ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\Documents and Settings\...\My Documents\My Database\Text;" & _ "Extended...

You could try something like this: http://msmvps.com/blogs/deborahk/archive/2009/08/25/reading-comma-delimited-files-textfieldparser.aspx Which uses TextFieldParser. Hope this helps.