I've been given the task of parsing some text files and entering the data into our SQL database. The files start with a couple of lines of explanatory text, one line of which contains the date of the report. The date is in the format month day year. There are no commas in the date and the month is the name of the month (ie January, February, etc). What would some vb.net code look like that would recognize dates in this format and how can I convert this to a date variable that can be stored in my SQL Server database?
In addition, much of the text following the explanatory text is lines of data that contain 3 items. A number in columns 1 through 7, text data in columns 8 through 120 and another number in colums 121 through 130. What's the best way to parse the three items from each line?
Thanks so much for the help.
In addition, much of the text following the explanatory text is lines of data that contain 3 items. A number in columns 1 through 7, text data in columns 8 through 120 and another number in colums 121 through 130. What's the best way to parse the three items from each line?
Thanks so much for the help.