//1 declare variables
string value1, value2, value3; //up to value 33
//2 use textreader to read in log file
read log file line by line
//3 identify the separators in the log file - this is a page break or (chr(12))
for each line in log file that has page break
{
if line not equal to blank //has no values
{
read 1st line store to value1
read 2nd line store to value2
read 3rd line store to value2
}
// Continue this as there are 33 line to each record
}
//get the data from the stored values split to get the data
string[] line1 = value1.split(" ");
string surname =line1[0]
// and i attempt to get all the values once i get it i insert it into a database
//but inserting into the database is the easy bit

I think i am definitely loosing people on this one so i'll try to explain better. My first post shows an example of just 1 record on a text file that has about 4000 records. Each record is separated by a page break.

Unfortunately for me I cant get the data in a comma delimited format or xml or any other format which would make my life easier.

So I have to write something to manually retrieve the data and store it in a database, the thing is I dont know how to start this which is why i'm asking for help.

I found this link which i'm hoping would set me on the right path and also let you see what i mean.