Exclude the records based on space.

[Shriram]

Hi,

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)

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:

Code: Select all

OMIT COND = (20,6,CH,EQ,C' '),OR,(22,3,CH,EQ,C' '),OR, (23,2,CH,EQ,C' '))

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.

[nicc]

Try reading up on String Search (SS) in the manual.