some text entered with date time field 04/09/2009 11:18:26 AM and then some more text</pre > > >and i need to extract the "04/09/2009 11:18:26 AM" or what ever datetime is present >thanks in advanceSomething like this:
Create Cursor results (result T) Index On result Tag result cText="some text entered with date time field 04/09/2009 11:18:26 AM and then some more text" nLen=Len(cText) For nLoop=1 To nLen cTrialtext=Substr(cText,nLoop,22) tTrial=Ctot(cTrialtext) If Empty(tTrial) Loop Endif If Seek(tTrial,'results','result')=.T. Loop Endif Insert Into results Value(tTrial) Endfor Select results Browse Close Databases All