if there is another way to do this .. or is this pretty much it?
The sentence can look like this .. item in bold is the text needed
05/24/06 16:00 -- Start working on #1
VB Code:
iPos = (InStr(sTemp, "-- ") + 3) ' START POINT iPoe = InStr(iPos, sTemp, " ") ' END POINT sTemp = Trim$(Mid$(sTemp, iPos, (iPoe - iPos))) ' GET TEXT




Reply With Quote