JailDoctor

You may simply trim your array like this: _ArrayTrim($YourDate,6,1)

I am entering data from excel files into a web form. If the client's name already exists, a Javascript bootstrap displays an error. HTML is <div class="alert alert-danger">New client failed to save. Clientname has already been taken. </div> Dim $oAlert boolean $oAlert = Send("^fNew client failed to save. Clientname has already been taken{ENTER}") MsgBox($MB_SYSTEMMODAL, "", $oAlert) I tried sending Ctrl + F to find the string "New client failed to save. Clientname has already been taken." and that finds the text. The attempt to generate a true or false state failed. The string is highlighted in the web page but I can't figure out how to tell if it was found. Thank you.

The ExcelEX alpha 6 zip file is empty or corrupt. Is there another place from where to download it?

Malkey, I get an "error allocating memory" message withthe code.

The files are insurance claims expanding about two years. that's why the are so large Guiness. Thanks Malkey, I will try your code.

It took 10 seconds to count 3,005,950 in a 1.1 GB file. I stoped it after afte 3 minutes on my 40 GB file.

Thak you guys. I will research what is Windows port of wc. wc -l <file>, learn to use it and will let you know.

HI guys, I borrowed stuff from here to count lines in extremelly large txt files. This works fine for files smaller than 1/2 GB. Larger files (1.1 GB) makes the script stops with a message "error allocating memory." I have some files as big as 40 GB that I will need to count their lines. Thanks. Here is the code: Local $message = "Please choose a file to count its lines." Local $var = FileOpenDialog($message, @MyDocumentsDir & "\", "Text (*.txt;*.csv)", 1 + 4) If @error Then MsgBox(64, "JailDoctor", "No File chosen",5) Exit Else $var = StringReplace($var, "|", @CRLF) Local $CountLines = _FileCountLines($var) EndIf MsgBox(64,"Lines Total" , "There are " & $CountLines - 1 & " lines in file " & $var)

That was it Water, thanks. I checked my "Autoit3" folders and there was no "_OL_Warnings.exe" file. So leaving the () blank did the trick. Thanks again.

Thanks Melba, this is going to be very useful because I am now working with a bunch of txts from different sources and of course each one of them assures me their format is the correct format.

No Jos, it didn't work for some reason. The important thing is that it works on the designated files.

Thanks Melba, Could it possible have to do with the numbers at the beginning of each line? It does work on the files I need to concatenate. Tab delimited txt files that list the field names at the top. I only need the name of the fields on the first page, not the rest.

You are right Jos! I tried with the real file to which I need to apply this and it worked!

Its a really small file. Test.txt

But my lines end with @CRLF Jos, I'm confused now . How do I fix this. Should I open the UDF and change the LF to CRLF?