Replacing text (date time string entries)

From: "Odie" <Odie@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Wed, 30 Mar 2005 12:03:01 -0800

I have several documents with several text lines beginning with date time
string entries like:

20000101000000.375 blah blah
20000101000000.888 blah blah
20000101000001.346 blah blah
20000101000001.789 blah blah
20000101000002.104 blah blah
etc

The format is currently YYYYMMDDHHMMSS.SSS
I want to loop through each line and convert it YYYYMMDDSSSSS.SS

In other words replace each hours mins and seconds into total seconds.

Can anyone provide some suggestions?

TIA
.

Follow-Ups:
- Re: Replacing text (date time string entries)
  - From: Jay Freedman

Prev by Date: Unicode String Parameters in DLL's
Next by Date: Re: Add my own methods to a combobox
Previous by thread: Unicode String Parameters in DLL's
Next by thread: Re: Replacing text (date time string entries)
Index(es):
- Date
- Thread

Relevant Pages

Re: Replacing text (date time string entries)
... "Jay Freedman" wrote: ... >>string entries like: ... >>20000101000000.375 blah blah ... > Dim strTime As String ...
(microsoft.public.word.vba.general)
Re: Replacing text (date time string entries)
... >string entries like: ... >20000101000000.375 blah blah ... Dim oRg As Range ... Dim strTime As String ...
(microsoft.public.word.vba.general)
Re: Nintendos big 24th Jan announcement
... >blah blah blah. ... blah, blahblahblah, blah! ... travelling by telephone" - Syd Barret 1967 ... Prev by Date: ...
(uk.games.video.misc)
Re: Ease up on me
... BethO wrote: ... > I have not been in this newsgroup in a very long time. ... > actually feel good to save the life of an blah blah blah. ... Prev by Date: ...
(alt.fan.howard-stern)
Re: brad jesness web page: Jave the Hut
... >>> well ummm.. ... >>> tags, blah blah blah' crap. ... >> I wonder if educating him about .htaccess would make his head explode... ... Prev by Date: ...
(sci.psychology.psychotherapy)