String help

[excalibur78]

I have a datetime with user name string and I need to parse out the datetime. Sample: 2/7/2003 8:48:04 AM by BBROWN
I deally I just want the date (2/7/2003) out of that string. My patience has been exusted with crystal for the day. Any help would be much appreciated.


Thanks,


David

 

[SmpTraining]

This should give you some ideas:

StringVar myText:="2/7/2003 8:48:04 AM by BBROWN";
StringVar tmp:= left(myText, instr(myText," ")-1);
cdate (tmp)

Steve Phillips, Crystal Consultant

 

[synapsevampire]

Is the word "by" always there?

If so, just use a formula containing:

left({table.field}, instr({table.field}, " by&quot)

If not, you can check for the AM or PM using:

If instr({table.field}, "AM&quot > 0 then
left({table.field}, instr({table.field}, "AM&quot+1)
else
left({table.field}, instr({table.field}, "PM&quot+1)

If you want to make a real datetime from either, wrap the formulas with cdatetime(), as in:

cdatetime(left({table.field}, instr({table.field}, " by&quot))

-k

 

[synapsevampire]

By the way, once you have a real date from it, you can right click it and select format field->Datetime->Customize and format it any way you want, so it can show just the MM/DD/YYYY.

-k

 

[excalibur78]

I got it thanks a ton everyone. Now I can go home and not have to work late =)