Hi, ich programmiere grad eine Software für Arbeitsrapport für eine Firma, hab ein Problem, in manchen Feldern werden die Texte durch Splitt falsch gesetzt, komischerweise bei anderen nicht! Guckt:
ich öffne sie aus einer datei per readalllines und splitte sie dann, code:
So sieht der inhalt einer Datei aus:
ich öffne sie aus einer datei per readalllines und splitte sie dann, code:
VB.NET-Quellcode
- Sub OpenFile(FileName As String)
- Dim alllines As String() = IO.File.ReadAllLines(FileName)
- Dim intline As Integer = 0
- For Each line As String In alllines
- intline += 1
- If intline = 1 Then
- Label1.Text = line
- Else
- If intline = 2 Then
- Datum01.Text = line.Split("||")(0)
- Tag01.Text = line.Split("||")(1)
- Von01.Text = line.Split("||")(2)
- Bis01.Text = line.Split("||")(3)
- Pause01.Text = line.Split("||")(4)
- Total01.Text = line.Split("||")(5)
- TotalBox01.Text = line.Split("||")(6)
- ElseIf intline = 3 Then
- Datum02.Text = line.Split("||")(0)
- Tag02.Text = line.Split("||")(1)
- Von02.Text = line.Split("||")(2)
- Bis02.Text = line.Split("||")(3)
- Pause02.Text = line.Split("||")(4)
- Total02.Text = line.Split("||")(5)
- TotalBox02.Text = line.Split("||")(6)
- ElseIf intline = 4 Then
- Datum03.Text = line.Split("||")(0)
- Tag03.Text = line.Split("||")(1)
- Von03.Text = line.Split("||")(2)
- Bis03.Text = line.Split("||")(3)
- Pause03.Text = line.Split("||")(4)
- Total03.Text = line.Split("||")(5)
- TotalBox03.Text = line.Split("||")(6)
- ElseIf intline = 5 Then
- Datum04.Text = line.Split("||")(0)
- Tag04.Text = line.Split("||")(1)
- Von04.Text = line.Split("||")(2)
- Bis04.Text = line.Split("||")(3)
- Pause04.Text = line.Split("||")(4)
- Total04.Text = line.Split("||")(5)
- TotalBox04.Text = line.Split("||")(6)
- ElseIf intline = 6 Then
- Datum05.Text = line.Split("||")(0)
- Tag05.Text = line.Split("||")(1)
- Von05.Text = line.Split("||")(2)
- Bis05.Text = line.Split("||")(3)
- Pause05.Text = line.Split("||")(4)
- Total05.Text = line.Split("||")(5)
- TotalBox05.Text = line.Split("||")(6)
- ElseIf intline = 7 Then
- Datum06.Text = line.Split("||")(0)
- Tag06.Text = line.Split("||")(1)
- Von06.Text = line.Split("||")(2)
- Bis06.Text = line.Split("||")(3)
- Pause06.Text = line.Split("||")(4)
- Total06.Text = line.Split("||")(5)
- TotalBox06.Text = line.Split("||")(6)
- ElseIf intline = 8 Then
- Datum07.Text = line.Split("||")(0)
- Tag07.Text = line.Split("||")(1)
- Von07.Text = line.Split("||")(2)
- Bis07.Text = line.Split("||")(3)
- Pause07.Text = line.Split("||")(4)
- Total07.Text = line.Split("||")(5)
- TotalBox07.Text = line.Split("||")(6)
- ElseIf intline = 9 Then
- Datum08.Text = line.Split("||")(0)
- Tag08.Text = line.Split("||")(1)
- Von08.Text = line.Split("||")(2)
- Bis08.Text = line.Split("||")(3)
- Pause08.Text = line.Split("||")(4)
- Total08.Text = line.Split("||")(5)
- TotalBox08.Text = line.Split("||")(6)
- ElseIf intline = 10 Then
- Datum09.Text = line.Split("||")(0)
- Tag09.Text = line.Split("||")(1)
- Von09.Text = line.Split("||")(2)
- Bis09.Text = line.Split("||")(3)
- Pause09.Text = line.Split("||")(4)
- Total09.Text = line.Split("||")(5)
- TotalBox09.Text = line.Split("||")(6)
- ElseIf intline = 11 Then
- Datum10.Text = line.Split("||")(0)
- Tag10.Text = line.Split("||")(1)
- Von10.Text = line.Split("||")(2)
- Bis10.Text = line.Split("||")(3)
- Pause10.Text = line.Split("||")(4)
- Total10.Text = line.Split("||")(5)
- TotalBox10.Text = line.Split("||")(6)
- ElseIf intline = 12 Then
- Datum11.Text = line.Split("||")(0)
- Tag11.Text = line.Split("||")(1)
- Von11.Text = line.Split("||")(2)
- Bis11.Text = line.Split("||")(3)
- Pause11.Text = line.Split("||")(4)
- Total11.Text = line.Split("||")(5)
- TotalBox11.Text = line.Split("||")(6)
- ElseIf intline = 13 Then
- Datum12.Text = line.Split("||")(0)
- Tag12.Text = line.Split("||")(1)
- Von12.Text = line.Split("||")(2)
- Bis12.Text = line.Split("||")(3)
- Pause12.Text = line.Split("||")(4)
- Total12.Text = line.Split("||")(5)
- TotalBox12.Text = line.Split("||")(6)
- ElseIf intline = 14 Then
- Datum13.Text = line.Split("||")(0)
- Tag13.Text = line.Split("||")(1)
- Von13.Text = line.Split("||")(2)
- Bis13.Text = line.Split("||")(3)
- Pause13.Text = line.Split("||")(4)
- Total13.Text = line.Split("||")(5)
- TotalBox13.Text = line.Split("||")(6)
- ElseIf intline = 15 Then
- Datum14.Text = line.Split("||")(0)
- Tag14.Text = line.Split("||")(1)
- Von14.Text = line.Split("||")(2)
- Bis14.Text = line.Split("||")(3)
- Pause14.Text = line.Split("||")(4)
- Total14.Text = line.Split("||")(5)
- TotalBox14.Text = line.Split("||")(6)
- ElseIf intline = 16 Then
- Datum15.Text = line.Split("||")(0)
- Tag15.Text = line.Split("||")(1)
- Von15.Text = line.Split("||")(2)
- Bis15.Text = line.Split("||")(3)
- Pause15.Text = line.Split("||")(4)
- Total15.Text = line.Split("||")(5)
- TotalBox15.Text = line.Split("||")(6)
- ElseIf intline = 17 Then
- Datum16.Text = line.Split("||")(0)
- Tag16.Text = line.Split("||")(1)
- Von16.Text = line.Split("||")(2)
- Bis16.Text = line.Split("||")(3)
- Pause16.Text = line.Split("||")(4)
- Total16.Text = line.Split("||")(5)
- TotalBox16.Text = line.Split("||")(6)
- ElseIf intline = 18 Then
- Datum17.Text = line.Split("||")(0)
- Tag17.Text = line.Split("||")(1)
- Von17.Text = line.Split("||")(2)
- Bis17.Text = line.Split("||")(3)
- Pause17.Text = line.Split("||")(4)
- Total17.Text = line.Split("||")(5)
- TotalBox17.Text = line.Split("||")(6)
- ElseIf intline = 19 Then
- Datum18.Text = line.Split("||")(0)
- Tag18.Text = line.Split("||")(1)
- Von18.Text = line.Split("||")(2)
- Bis18.Text = line.Split("||")(3)
- Pause18.Text = line.Split("||")(4)
- Total18.Text = line.Split("||")(5)
- TotalBox18.Text = line.Split("||")(6)
- ElseIf intline = 20 Then
- Datum19.Text = line.Split("||")(0)
- Tag19.Text = line.Split("||")(1)
- Von19.Text = line.Split("||")(2)
- Bis19.Text = line.Split("||")(3)
- Pause19.Text = line.Split("||")(4)
- Total19.Text = line.Split("||")(5)
- TotalBox19.Text = line.Split("||")(6)
- ElseIf intline = 21 Then
- Datum20.Text = line.Split("||")(0)
- Tag20.Text = line.Split("||")(1)
- Von20.Text = line.Split("||")(2)
- Bis20.Text = line.Split("||")(3)
- Pause20.Text = line.Split("||")(4)
- Total20.Text = line.Split("||")(5)
- TotalBox20.Text = line.Split("||")(6)
- ElseIf intline = 22 Then
- Datum21.Text = line.Split("||")(0)
- Tag21.Text = line.Split("||")(1)
- Von21.Text = line.Split("||")(2)
- Bis21.Text = line.Split("||")(3)
- Pause21.Text = line.Split("||")(4)
- Total21.Text = line.Split("||")(5)
- TotalBox21.Text = line.Split("||")(6)
- ElseIf intline = 23 Then
- Datum22.Text = line.Split("||")(0)
- Tag22.Text = line.Split("||")(1)
- Von22.Text = line.Split("||")(2)
- Bis22.Text = line.Split("||")(3)
- Pause22.Text = line.Split("||")(4)
- Total22.Text = line.Split("||")(5)
- TotalBox22.Text = line.Split("||")(6)
- ElseIf intline = 24 Then
- Datum23.Text = line.Split("||")(0)
- Tag23.Text = line.Split("||")(1)
- Von23.Text = line.Split("||")(2)
- Bis23.Text = line.Split("||")(3)
- Pause23.Text = line.Split("||")(4)
- Total23.Text = line.Split("||")(5)
- TotalBox23.Text = line.Split("||")(6)
- ElseIf intline = 25 Then
- Datum24.Text = line.Split("||")(0)
- Tag24.Text = line.Split("||")(1)
- Von24.Text = line.Split("||")(2)
- Bis24.Text = line.Split("||")(3)
- Pause24.Text = line.Split("||")(4)
- Total24.Text = line.Split("||")(5)
- TotalBox24.Text = line.Split("||")(6)
- ElseIf intline = 26 Then
- Datum25.Text = line.Split("||")(0)
- Tag25.Text = line.Split("||")(1)
- Von25.Text = line.Split("||")(2)
- Bis25.Text = line.Split("||")(3)
- Pause25.Text = line.Split("||")(4)
- Total25.Text = line.Split("||")(5)
- TotalBox25.Text = line.Split("||")(6)
- ElseIf intline = 27 Then
- Datum26.Text = line.Split("||")(0)
- Tag26.Text = line.Split("||")(1)
- Von26.Text = line.Split("||")(2)
- Bis26.Text = line.Split("||")(3)
- Pause26.Text = line.Split("||")(4)
- Total26.Text = line.Split("||")(5)
- TotalBox26.Text = line.Split("||")(6)
- ElseIf intline = 28 Then
- Datum27.Text = line.Split("||")(0)
- Tag27.Text = line.Split("||")(1)
- Von27.Text = line.Split("||")(2)
- Bis27.Text = line.Split("||")(3)
- Pause27.Text = line.Split("||")(4)
- Total27.Text = line.Split("||")(5)
- TotalBox27.Text = line.Split("||")(6)
- ElseIf intline = 29 Then
- Datum28.Text = line.Split("||")(0)
- Tag28.Text = line.Split("||")(1)
- Von28.Text = line.Split("||")(2)
- Bis28.Text = line.Split("||")(3)
- Pause28.Text = line.Split("||")(4)
- Total28.Text = line.Split("||")(5)
- TotalBox28.Text = line.Split("||")(6)
- ElseIf intline = 30 Then
- Datum29.Text = line.Split("||")(0)
- Tag29.Text = line.Split("||")(1)
- Von29.Text = line.Split("||")(2)
- Bis29.Text = line.Split("||")(3)
- Pause29.Text = line.Split("||")(4)
- Total29.Text = line.Split("||")(5)
- TotalBox29.Text = line.Split("||")(6)
- ElseIf intline = 31 Then
- Datum30.Text = line.Split("||")(0)
- Tag30.Text = line.Split("||")(1)
- Von30.Text = line.Split("||")(2)
- Bis30.Text = line.Split("||")(3)
- Pause30.Text = line.Split("||")(4)
- Total30.Text = line.Split("||")(5)
- TotalBox30.Text = line.Split("||")(6)
- ElseIf intline = 32 Then
- Datum31.Text = line.Split("||")(0)
- Tag31.Text = line.Split("||")(1)
- Von31.Text = line.Split("||")(2)
- Bis31.Text = line.Split("||")(3)
- Pause31.Text = line.Split("||")(4)
- Total31.Text = line.Split("||")(5)
- TotalBox31.Text = line.Split("||")(6)
- End If
- End If
- Next
- End Sub
So sieht der inhalt einer Datei aus:
Quellcode
- 01.01.2014||Mittwoch||00:00||00:00||0.00||00.00||test
- 02.01.2014||Donnerstag||00:00||00:00||0.00||00.00||test
- 03.01.2014||Freitag||00:00||00:00||0.00||00.00||test
- 04.01.2014||Samstag||00:00||00:00||0.00||00.00||test
- 05.01.2014||Sonntag||00:00||00:00||0.00||00.00||test
- 06.01.2014||Montag||00:00||00:00||0.00||00.00||test
- 07.01.2014||Dienstag||00:00||00:00||0.00||00.00||test
- 08.01.2014||Mittwoch||00:00||00:00||0.00||00.00||test
- 09.01.2014||Donnerstag||00:00||00:00||0.00||00.00||test
- 10.01.2014||Freitag||00:00||00:00||0.00||00.00||test
- 11.01.2014||Samstag||00:00||00:00||0.00||00.00||test
- 12.01.2014||Sonntag||00:00||00:00||0.00||00.00||test
- 13.01.2014||Montag||00:00||00:00||0.00||00.00||test
- 14.01.2014||Dienstag||00:00||00:00||0.00||00.00||test
- 15.01.2014||Mittwoch||00:00||00:00||0.00||00.00||test
- 16.01.2014||Donnerstag||00:00||00:00||0.00||00.00||test
- 17.01.2014||Freitag||00:00||00:00||0.00||00.00||test
- 18.01.2014||Samstag||00:00||00:00||0.00||00.00||test
- 19.01.2014||Sonntag||00:00||00:00||0.00||00.00||test
- 20.01.2014||Montag||00:00||00:00||0.00||00.00||test
- 21.01.2014||Dienstag||00:00||00:00||0.00||00.00||test
- 22.01.2014||Mittwoch||00:00||00:00||0.00||00.00||test
- 23.01.2014||Donnerstag||00:00||00:00||0.00||00.00||test
- 24.01.2014||Freitag||00:00||00:00||0.00||00.00||test
- 25.01.2014||Samstag||00:00||00:00||0.00||00.00||test
- 26.01.2014||Sonntag||00:00||00:00||0.00||00.00||test
- 27.01.2014||Montag||00:00||00:00||0.00||00.00||test
- 28.01.2014||Dienstag||00:00||00:00||0.00||00.00||test
- 29.01.2014||Mittwoch||00:00||00:00||0.00||00.00||test