Skip to Content
Former Member
Oct 06, 2009 at 04:11 PM

extracting data from a field



I have a comment field with manay information on it. One record will have text and date and numbers to it. I would like to pull the codes from 1001, 1002 up to 1012 from the field. Example comment:

1. 1005 9-30-09 update only

2. EDC 1008 9-15-09 changes

I would like to extract the data 1005 and add in a separate column or create a new field for Code. The second example, I would like to get the data 1008. The date that follows the number 1005 in example 1, I also would like to put in another field called Received Date except for codes 1001 - 1004.

Can you please give me suggestions on how to handle this? I am using Crystal 10.

Thank you!