Exclude the records based on space.
Posted: Mon Jun 27, 2016 2:27 pm
Hi,
I have an alpha-numeric field with length 6. The values this field can take are:
If there is a space in the field, I need to remove such records from input. I am using this sort card. 20 is the starting posistion:
In this I have used multiple ORs. Can this be written in a better way. For example, if the filed is more than 20 characters, then writing so many ORs will make look ugly. Any guidance in this regard wil lbe very nice.
I have an alpha-numeric field with length 6. The values this field can take are:
Code: Select all
" " (All Spaces)Code: Select all
"xy " (3 Spaces)Code: Select all
"xyz " (2 Spaces)Code: Select all
OMIT COND = (20,6,CH,EQ,C' '),OR,(22,3,CH,EQ,C' '),OR, (23,2,CH,EQ,C' '))