CSV2DataTable – Importing the data contained in a CSV file into a new DataTable

CSV2DataTable – Importing the data contained in a CSV file into a new DataTable

' Import the data contained in a CSV file into a new DataTable. By default the ' values are Tab delimited, but you can use the second overload version to use ' any other string you want.'' Example:'    Dim table As DataTable = CSV2DataTable("D:Users.txt")'    DataGrid1.DataSource = tableFunction CSV2DataTable(ByVal filename As String) As DataTable    Return CSV2DataTable(filename, vbTab)End FunctionFunction CSV2DataTable(ByVal filename As String, ByVal sepChar As String) As _    DataTable    Dim reader As System.IO.StreamReader    Dim table As New DataTable    Dim colAdded As Boolean = False    Try        ' open a reader for the input file, and read line by line        reader = New System.IO.StreamReader(filename)        Do While reader.Peek() >= 0            ' read a line and split it into tokens, divided by the specified             ' separators            Dim tokens As String() = System.Text.RegularExpressions.Regex.Split _                (reader.ReadLine(), sepChar)            ' add the columns if this is the first line            If Not colAdded Then                For Each token As String In tokens                    table.Columns.Add(token)                Next                colAdded = True            Else                ' create a new empty row                Dim row As DataRow = table.NewRow()                ' fill the new row with the token extracted from the current                 ' line                For i As Integer = 0 To table.Columns.Count - 1                    row(i) = tokens(i)                Next                ' add the row to the DataTable                table.Rows.Add(row)            End If        Loop        Return table    Finally        If Not reader Is Nothing Then reader.Close()    End TryEnd Function

Share the Post:
XDR solutions

The Benefits of Using XDR Solutions

Cybercriminals constantly adapt their strategies, developing newer, more powerful, and intelligent ways to attack your network. Since security professionals must innovate as well, more conventional endpoint detection solutions have evolved

AI is revolutionizing fraud detection

How AI is Revolutionizing Fraud Detection

Artificial intelligence – commonly known as AI – means a form of technology with multiple uses. As a result, it has become extremely valuable to a number of businesses across

AI innovation

Companies Leading AI Innovation in 2023

Artificial intelligence (AI) has been transforming industries and revolutionizing business operations. AI’s potential to enhance efficiency and productivity has become crucial to many businesses. As we move into 2023, several

data fivetran pricing

Fivetran Pricing Explained

One of the biggest trends of the 21st century is the massive surge in analytics. Analytics is the process of utilizing data to drive future decision-making. With so much of

kubernetes logging

Kubernetes Logging: What You Need to Know

Kubernetes from Google is one of the most popular open-source and free container management solutions made to make managing and deploying applications easier. It has a solid architecture that makes

ransomware cyber attack

Why Is Ransomware Such a Major Threat?

One of the most significant cyber threats faced by modern organizations is a ransomware attack. Ransomware attacks have grown in both sophistication and frequency over the past few years, forcing

data dictionary

Tools You Need to Make a Data Dictionary

Data dictionaries are crucial for organizations of all sizes that deal with large amounts of data. they are centralized repositories of all the data in organizations, including metadata such as