delete line # / text file / vba exel

Question

I have a huge text file where the two first lines are relatively short but the third one is very large (29077437 chars).  Therefore, to save time,

I wonder if there is a function in VBA Excel which permit us to delete, let say the second line and to save it without having to read the third line?

ALP

Answer 1

I suppose you could do this with a combination of Line Input# and Print#?

That wouldn't really modify the original text file, but you could copy the lines that you would like to keep, (based on the criteria that you specify) and output the data to a new text file.

https://msdn.microsoft.com/en-us/library/office/gg264130.aspx

Data read with Line Input # is usually written from a file with Print #.

The Line Input # statement reads from a file one character at a time until it encounters a carriage return (Chr(13)) or carriage return–linefeed (Chr(13) + Chr(10)) sequence. Carriage return–linefeed sequences are skipped rather than appended to the character string.

=======================================

Something like this?

(Warning: "Aircode")

IF this text file is ALWAYS going to be 3 lines as you describe above:

Dim i As Integer

i=0

Dim TextLine 
Open "Readfile" For Input As #1 ' Open file.Do While Not EOF(1) ' Loop until end of file. i = i + 1If i <> 2 Then 'You said you wanted to ship the second line
 Line Input #1, TextLine ' Read line into variable.End IfOpen "WriteFile" For Output as #2Print# TextLineClose #2
 
Loop 
Close #1 ' Close file. 

Edit:

This might be worth a read as well?

http://software-solutions-online.com/2014/03/15/vba-modify-existing-text-file/

Answer 2

Yes you are wright.  My question is not clear.  It was in my head but not on the web.

So as I have mentioned, in a huge text file, the two first lines are short but the thirds one is very huge.

I have try to read the first and the last line (discard the second one) then saved the file but it is very time consuming (few minutes).  It is too long.

So I was looking for a function which will permits me to open a text file, delete the second line thereafter saving this file.

Answer 3

I have a huge text file where the two first lines are relatively short but the third one is very large (29077437 chars).  Therefore, to save time,

I wonder if there is a function in VBA Excel which permit us to delete, let say the second line and to save it without having to read the third line?

You can certainly read the file line by line, using the good old Basic I/O statement Line Input.  So you could read the first two lines and close the file. I don't know what you mean by "delete the second line", but reading is straightforward enough.

Answer 4

I am interested in both.  The VBA macro in Excel as well as in Access

Answer 5

You posted in the Access topic. I suggest you repost under the Excel topic.