OMIT the records if space occurs in any place of a Five length filed....

1 post / 0 new
Offline
Joined: 12/18/2013 - 13:40
OMIT the records if space occurs in any place of a Five length filed....

Hi All...

My requirement is...

I have field with Length 5 (Alpha Numeric)

This field contains the below values

" " (All 5 Spaces)
"AB " (3 Spaces)
"ABC " (2 Spaces)

If a Space occurs in any place, I want to pull/omit those records...

This i have achieved by using the below Sort card..

OMIT COND = (30,5,CH,EQ,C' '),OR,(32,3,CH,EQ,C' '),OR,
(33,2,CH,EQ,C' '))

But i am looking better way of achieving, instead of coding multiple OR conditions...

Any help can pls throw some ligths!!!

Thanks in Advance,
Veera.

Sponsored Listing