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.