Crystal Reports - How to extract data from a data string
Posted on 2011-03-07
I have a database column which is a varchar string. In it, the user stores an alpha string which (somewhere in the string) contains a date (i.e. 03-07-11). I need to be able to extract the date part of the string to a string variable and use this on a report.
An example of two of the strings are '03-07-11 DAVISON COMPANY' and 'WORTH VILLAGE 03-03-11.' In example one, I want to extract '03-07-11' and in example two, I need to extract '03-03-11.
I appreciate your help.