I think the response to Carol's post will work.
I'm showing you the last field of seven in the server log.
(other fields are date, port, time, etc).
Last field is the one I have to parse via query.
Typical contents of last field in file would be:
Bill.Gates connected for 0 hours, 8 minutes, 37 seconds
Steve.Ballmer connected for 0 hours, 12 minutes, 29 seconds
Bjaren.Soustroup connected for 0 hours, 28 minutes, 45 seconds
Larry.Ellison connected for 0 hours, 14 minutes, 24 seconds
Linus.Torvalds connected for 0 hours, 9 minutes, 32 seconds
every entry is slightly different, depending on the name length.
But, with your help I have enough examples to generate the result of:
Name LogTime
Bill Gates 08:37
Steve.Ballmer 12:29
Larry.Ellison 28:45
etc.
Thanx
Les said:
Is there any way that you can maybe import the server log
into access, so that access creates separate columns for
your data? You might try delimited option. At least you
would have less work to do if the data was separated.
Good luck.
-----Original Message-----
Yeah, already used that, but I'm having to run about six
queries to get my final result. Here's the scoop:
Server Log record generates continuous output that looks
like this in one record:
Bill Gates connected for 0 hours, 8 minutes, 37 seconds
result should be parsed like into two fields:
Name Field TimeLogged On
Bill Gates 8:37
-----Original Message-----
Hi,
Posted answer for you under Carol's post about partial
text string.
-----Original Message-----
If a name record contains a certain string
(let's say "onimonopedia") and I'd like to remove
any occurance of that string in the record
FROM A QUERY, how do I do that?
Is it an IIF([name],"onimonopedia","") type
statment. I can't think of any use of InStr to
work....
.
.
.
