View Single Post
 
Old 01-25-2021, 10:24 PM
SMehta SMehta is offline Windows 10 Office 2013
Novice
 
Join Date: Jan 2021
Posts: 29
SMehta is on a distinguished road
Default

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
Reply With Quote