Need help with VB.NET solution - transitioning from access vba to vb.net.
Posted on 2012-04-12
I'm reading a csv file with File System Object and have to determine out of each column what's the greatest length of a strings value! So obviously I would need to go through the entire text file and store each row into memory - then cycle through. I do have the code to read the csv file using the file system object already - what I do not know how to do is to take the information and put it into an arraylist per each column? 1st column is qty, 2nd is description and 3rd is manufacturer.
What makes it confusing is as I do research it would seem I need to create a class preferably?
Why the access vba to vb.net statement above?
I used to do this in access vba by taking each and row and putting it into a table - then running a sql statement that sorted on the Len(column) in descending order. And the DAO recordset was easy to do to pull info - but I'm still learning vb.net and object oriented programming.
objStream = FSO.OpenTextFile(sFileName, 1, False, 0)
Do While Not objStream.AtEndOfStream
strLine = objStream.ReadLine
objStream = Nothing
Any help is much appreciated.