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

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. Stream File
13. GUI
14. GUI Applications
15. 2D Graphics
16. I18N Internationlization
17. Reflection
18. Regular Expressions
19. Security
20. Socket Network
21. Thread
22. Windows
23. XML
24. Database ADO.net
25. Design Patterns
Microsoft Office Word 2007 Tutorial
Java
Java Tutorial
Java Source Code / Java Documentation
Java Open Source
Jar File Download
Java Articles
Java Products
Java by API
C# / C Sharp
C# / CSharp Tutorial
ASP.Net
JavaScript DHTML
JavaScript Tutorial
JavaScript Reference
HTML / CSS
HTML CSS Reference
C / ANSI-C
C Tutorial
C++
C++ Tutorial
PHP
Python
SQL Server / T-SQL
Oracle PL / SQL
Oracle PL/SQL Tutorial
PostgreSQL
SQL / MySQL
MySQL Tutorial
VB.Net
VB.Net Tutorial » Development » CSV 
7. 31. 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. 31. CSV
7. 31. 1. Create CSV file
7. 31. 2. Read in and process a CSV file
7. 31. 3. Use system default editor to open a CSV file
ww___w._j__a_va_2__s.__c___o__m__ | Contact Us
Copyright 2003 - 08 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.