How to display a field up to a point 1

[kenp705]

I am using Crystal 11 and WinXP. I have a field called Nature.Code in which there are text strings like BUVE-Burglary of Vehicle. I need to create a new field that looks at this field and returns everything up to the "-". It is not always the first 4 characters. I am new to this and am sure there is an easy answer. Any help is much appreciated.....

 

[hilfy]

Create a formula, something like this:

Left({table.field}, (InStr({table.field}, '-') - 1))

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[kenp705]

Thank you very much. Works like a charm.......