Processing TXT text in the Hague, because the file is more than 50 m memory how to solve?-CodePudding

 Open V For Binary As # 1 
M=Space (LOF) (1) 
Get # 1 and M 
Close # 1 

M=Replace (M, vbCrLf, vbLf) 'will be replaced by a newline carriage return + a newline, to prevent wrong operation 
M=Replace (M, vbCr vbLf) 'will return characters replaced by a newline 
M=Replace (M, vbLf, vbCrLf) 'will be replaced a newline carriage return + newline 

Kill V 
The Open V For Binary As # 1 
Put # 1,, M 
Close # 1

I use the above procedure will TXT file to get rid of Mr Hague, but when the TXT file is more than 50 m will be out of memory, who is a good way to solve

CodePudding user response:

Binary segmentation, speaking, reading and writing.

If you is a text file, why want to open in binary way? And if it's text, you can also press the line read.

You can search for VB access to the file.

CodePudding user response:

Binary segmentation processing,

M=Space (1024)

CodePudding user response:

M=Space (LOF) (1)
String overflow, in the section I deal with how to modify this code? Consult!!!!!!

CodePudding user response:

Did not tell you? Don't read in segmentation processing, processing a, write a new file, and delete the old file, the new file name as the old file name,