extracting data from a field

[Former Member]

Hi,

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!

[Former Member · Accepted solution]

You could also try this: Use the InStr function to determine if your codes exist in the memo field and then display something:

If InStr(,"1002") then "1002" else If InStr(,"1005") then "1005"

etc.

[Former Member]

Marinette,

Try this:

left(right(split({field},'-')[1],5),4)

I hope that helps,

Regards,

Zack H.

[Former Member]

Please use the string functions meaning Right,Left and Mid along with the Instr function. For example:

Right(,8) will give you the date. Please refer the CR help on how to use these functions.