Display Longest Lines Length and Content of ReadFile variable Topic is solved

[Visioneer]

Hi,
I have a very long txt file to be imported into a database, and I need to define the longest possible field, VarChar(??)
I would like to Loop, Parse the var myF to get and MsgBox the longest number and content of longest line.

So far I have this. Sadly, I have forgotten how to Parse with incrementing var.

Code: Select all

FileRead, myF, myList.txt
;Get and Display length and content of Longest line in file.
myL =
myT =

Loop, Parse, myF, `n, `r 
{
if (StrLen(A_LoopField) > StrLen(myL)) {

myL :=  StrLen(A_LoopField) 

myT = %A_LoopField%

continue
}
else
{
myL := StrLen(A_LoopField)
}

}

MsgBox, 4096,, Longest myList.txt Line Content is: %myT% -  Longest Line Length is: %myL%
ExitApp

I know it is way off, but this is a start.
Somehow you can Loop and keep, yet increment the detection vars.

Thanks,

[ahk7]

If the file fits in memory you can sort the file by line length https://autohotkey.com/board/topic/23093-sort-a-text-file-according-to-line-length/

[BoBo]

Code: Select all

FileRead, myF, myList.txt
psl := 0 

Loop, Parse, myF, `n, `r 
	{	
	        if (StrLen(A_LoopField) > psl) {
			psl := StrLen(A_LoopField)
			ln	:= A_LoopField
			}
	}

MsgBox % "Longest myList.txt line content is:`t" ln "`nLongest Line Length is:`t" psl
ExitApp

Not tested.

[Visioneer]

Hi Thanks Bobo,

Thanks works great. Saved me a lot of time updating some stragglers in an 850,000+ txt file.
It helped me add a new class of situation to auto-edit Postal Codes.
Then I'll run it again until I have them all.
Thanks a lot

Thanks ahk7, I reviewed that link. It was helpful too. I never trusted sorting with AHK.
Maybe I'll give it a try if I need to find many many more of these odd balls.