Read in and process a CSV file : CSV « Development « VB.Net Tutorial

Home
VB.Net Tutorial
1.Language Basics
2.Data Type
3.Operator
4.Statements
5.Date Time
6.Class Module
7.Development
8.Collections
9.Generics
10.Attributes
11.Event
12.LINQ
13.Stream File
14.GUI
15.GUI Applications
16.Windows Presentation Foundation
17.2D Graphics
18.I18N Internationlization
19.Reflection
20.Regular Expressions
21.Security
22.Socket Network
23.Thread
24.Windows
25.XML
26.Database ADO.net
27.Design Patterns
VB.Net
VB.Net by API
VB.Net Tutorial » Development » CSV 
7.33.2.Read in and process a CSV file
Public Class Tester
    Public Shared Sub Main
        Dim wholeFile As String
        Dim lineData() As String
        Dim fieldData() As String

        Dim filePath As String = My.Computer.FileSystem.CurrentDirectory & "\Test.csv"
        wholeFile = My.Computer.FileSystem.ReadAllText(filePath)

        lineData = Split(wholeFile, vbNewLine)
        For Each lineOfText As String In lineData
            fieldData = lineOfText.Split(",")
            For Each wordOfText As String In fieldData
                Console.WriteLine(wordOfText)
            Next wordOfText
            Console.WriteLine("")
        Next lineOfText
        
    End Sub

End Class
Alpha
Beta
Gamma1.1
 2.3
 4.5
7.33.CSV
7.33.1.Create CSV file
7.33.2.Read in and process a CSV file
7.33.3.Use system default editor to open a CSV file
www.java2java.com | Contact Us
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.