Parse String to Array or DataTable

Question

I'm trying to parse a long boring text document and parse and format it.

"7/29/2012 1:25:20 PM","Summary Plan/Second Floor /Master_VAV_2-24","Source :OEnd"
"7/29/2012 11:25:23 AM","Summary Plan/Second Floor /Master_VAV_2-24","Source :OStart"

I'd like to parse each value between the quotes but I cant find anything online to help me, I believe it's a matter of knowing what to call it and search for.

"date", "location", "type" would be the 3 values I want to parse it into, then I could run a loop for each item in datatable and format it as required.

ANY HELP would be great, thank you!

I'm thinking of using RegEx to get the rows and add them manually to an array, something like this.

Dim rx As New Regex(",", RegexOptions.IgnoreCase Or RegexOptions.Multiline)
Dim matches As MatchCollection = rx.Matches(strSource)
For Each match As Match In matches
Dim matchValue As String = match.Value
If Not list.Contains(matchValue) Then
    list.Add(matchValue)
End If
Next

Oded · Accepted Answer · 2012-07-30 21:18:53Z

3

This format appears to be CSV - use one of the many free and open source CSV parsers (google ".NET CSV parser" will return many results.

There is one that comes built in, in the Microsoft.VisualBasic.FileIO namespece - the TextFieldParser.

answered Jul 30, 2012 at 21:18

Oded

501k102 gold badges900 silver badges1k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Parse String to Array or DataTable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related