Yet another link found
Check for empty or blank lines while reading a text file
I really don't know whether the code in above link, pasted below, is a VBA code. ???
if not then how can we use the same VBA word to get the list of Blank line numbers from text file
Would really appreciate your input and guidance.
Code:
Option Strict On
Option Explicit On
Option Infer Off
Imports System.IO.Path
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, _
ByVal e As System.EventArgs) _
Handles MyBase.Load
Dim desktop As String = _
Environment.GetFolderPath(Environment.SpecialFolder.Desktop)
Dim textFilePath As String = _
Combine(desktop, "ExampleTextFile.txt")
Dim blankLines() As Integer = GetBlankLines(textFilePath)
Stop
End Sub
Private Function GetBlankLines(ByVal textFilePath As String) As Integer()
Dim retVal() As Integer = New Integer() {}
If Not String.IsNullOrWhiteSpace(textFilePath) Then
If IO.File.Exists(textFilePath) Then
Dim lineNumber As Integer = 1
Dim tempList As New List(Of Integer)
Using rdr As New System.IO.StreamReader(textFilePath)
Do While rdr.Peek() >= 0
Dim itm As String = rdr.ReadLine.Trim
If String.IsNullOrWhiteSpace(itm) Then
tempList.Add(lineNumber)
End If
lineNumber += 1
Loop
End Using
If tempList.Count > 0 Then
retVal = tempList.ToArray
End If
End If
End If
Return retVal
End Function
End Class
SMehta
Thread 1: No: 46342 : Post No17 : TM 10