Question:
I have to read a CSV file row by row which is located in the Linux Server.
From the Sample code : http://www.example-code.com/vbdotnet/sftp_readTextFile.asp
I am able to read the file in the SFTP server.
In the sample code, they have mentioned the bytes for each row to read.
' Open a file for reading.
handle = sftp.OpenFile(_fileName, "readOnly", "openExisting")
If (handle = vbNullString) Then
MsgBox(sftp.LastErrorText)
Exit Function
End If
' Assume the file we are reading contains the following text:
' abcdefghijklmnopqrstuvwxyz1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ
' (in ANSI format -- i.e. one byte per char).
' Read 26 bytes:
Dim sText As String
sText = sftp.ReadFileText(handle, 26, "ansi")
If (sText = vbNullString) Then
MsgBox(sftp.LastErrorText)
Exit Function
End If
In my scenario, I have to use End of File. How to alter the code to read end of the line. This will help to solve the issue.