Separating text from .txt into colums in listview (VB.net mobile)

[Avngl]

Hey guys.

I want to separate each text into their own Column in VB.net.

How do I achieve this?

Screenshot:

Each entree is seperated with "|" . My Code:

Private Sub MenuItem3_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem3.Click
Dim folder As String = Environment.GetFolderPath(Environment.SpecialFolder.Personal)
Using sw As StreamWriter = File.AppendText("\My Expenses.txt")
 
sw.WriteLine(DateTimePicker.Text + Space(1) & "|" & Subject.Text + Space(4) & "|" & Category.Text + Space(5) & "|" & Amount.Text + Space(4) & "|" & Peyment.Text)
sw.Close()
End Using
End Sub
 

[MrMancunian]

Basically, you need to find out how the text is in the text-file. If it's line by line, you just start reading lines till EOF (End of File) and split each line on the character "|". You put them all in an multidimensional array so it looks like this:

[0][Date]
[0][Subject]
[0][Category]
[0][Amount]
[0][Payment]
[1][Date]
[1][Subject]
[1][Category]
[1][Amount]
[1][Payment]

The first column in your array is the line, the second contains the values you read from your textfile.

After that, it's just a matter of inserting your array in your table.