OK, this is a bit of an interesting job for anyone who can help out...
I have a txt file which reads like this:
VERSION = 1
RELOAD = 1
UPDATE = 20030417111736
CONNECTED CLIENTS = 2
CONNECTED SERVERS = 1
GB_DIR:200000:ANDREW BERRY EGNX:PILOT::29.880860:-103.699770:3816:0:T/B747/F:120:EGLL:FL320:EGNX:LAN:1:1:1200:0:40:1:I:1000:1100:1:30:4:30:EGBB:TESTING!:EGLL - HON - TNT - EGNX:::::::20030417111431
LAN:127.0.0.1:local:Local Windows FSD server:1
I need to read the following information out of each line and calculate a time:
The person's ID Number (200000 - the second number) and also the LAST number, "20030417111431" - which is the date in the form of YearMonthDayHourMinuteSecond - the time they connected. I need to then store this information EITHER:
until the connection is closed, OR keep writing it to the database... the only thing being physically logged for the future is the time, however the ID will be what I use to input into the correct record in the database.
Any help would be very very gratefully recieved!!