exclude fields that are null or have 4 blank spaces

[John1Chr]

Hi all,

I'm using Crystal 11.5 and running off an ODBC warehouse table and I'm trying to exclude all of the fields which are null or have 4 empty spaces in them.

So far, I have:

and not isnull({warehouse table.field})

and I'm able to exclude the null fields.

 

[mbDutch]

For the blank spaces you can use trim({table.field}) <>

 

[CR85user]

isnull({field}) or {field} like '*    *'

'J

CR8.5 / CRXI - Discovering the impossible

 

[dgillz]

Not Isnull{YourField}) or instr({YourField}," ")>0

The above will work regardless of where the 4 spaces are in the string.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html