Formula for field containing a word

[Tupence]

Hi All,

I am trying to find a formula for finding a six letter string within a field, in order to create a group

unfortunately the way the data is entered the six letter word could be anywhere in the field.

is there a formula function that could be used to do this?

thanks

 

[dgillz]

If instr({YourStringField},"abc123")>0 then "String Found" else "String Not Found".

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[Madawc]

Yes, both LIKE and IN. e.g.

{address.town} LIKE "Alice"

or

"Alice" IN {address.town}

Either command would give you "Alice Springs" and also "Alicegruf", if there was such a place. LIKE also allows fancy selections, 'wild cards'

It helps to give your Crystal version - 8, 8.5, 9, 10, 11 or whatever. Methods change between versions, and higher versions have extra options.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Tupence]

Thanks, that worked a treat!