regular expression pattern

Question

 

4/21/2003 :     On 4/21/2003 6:02:49 PM By DBROWN ::      ;   
 On 4/21/2003 7:04:41 PM By DBROWN :: 
  called on 4/19 ;

from the above string

can any one tell me the pattern to

extract the date preceded by 'On ' and name preceded by 'By'

Answer 1

Assuming that :: is not part of the name...

#On (.*?) By (.*?) ::#

Answer 2

Hi Pradeep, Did the post resolve the problem?

If so mark the post as the answer, so when others search the forums, they might be more inclined to look at a successful post than a non successful one...in the search results the Answered posts are bubbled to the top before the unanswered.

Or post why it failed for you. Thanks.