|
View previous topic :: View next topic
|
| Author |
Message |
mkk157
Active User
Joined: 17 May 2006
Posts: 310
|
|
|
|
I want to include those records that start with the Alphabets and to exclude those records that start with numbers.
Here I am using the sort card as
| Code: |
OPTION COPY
INCLUDE=(5,1,CH,EQ,C'A',OR,
5,1,CH,EQ,C'B',OR,
5,1,CH,EQ,C'C',OR,
5,1,CH,EQ,C'D',OR,
5,1,CH,EQ,C'E',OR,...............
5,1,CH,EQ,C'Z')
|
Can anyone suggest alternate for this.
Can I mention all these 26 conditions in a single condition. |
|
| Back to top |
|
 |
shankar.v
Active User
Joined: 25 Jun 2007
Posts: 196
Location: Bangalore
|
|
|
|
mkk157,
Please check with the following code for your requirement.
| Code: |
OPTION COPY
INCLUDE COND=(5,1,SS,EQ,C'ABCDEFGHIJKLMNOPQRSTUVWXYZ') |
|
|
| Back to top |
|
|
shankar.v
Active User
Joined: 25 Jun 2007
Posts: 196
Location: Bangalore
|
|
|
|
mkk157,
Please check with the following alternative codes for your requirement
| Code: |
OPTION COPY
INCLUDE COND=((5,1,CH,GE,C'A',AND,5,1,CH,LE,C'I'),OR,
(5,1,CH,GE,C'J',AND,5,1,CH,LE,C'R'),OR,
(5,1,CH,GE,C'S',AND,5,1,CH,LE,C'Z')) |
| Code: |
OPTION COPY
OMIT COND=(5,1,SS,EQ,C'1234567890') |
|
|
| Back to top |
|
|
mkk157
Active User
Joined: 17 May 2006
Posts: 310
|
|
|
|
shankar,
Here the records in the file are starting with Alphabet and numbers.
From those I need to include only those records which starts with Alphabets. i.e. the first character should be the Alphabet. |
|
| Back to top |
|
|
shankar.v
Active User
Joined: 25 Jun 2007
Posts: 196
Location: Bangalore
|
|
|
|
| Quote: |
shankar,
Here the records in the file are starting with Alphabet and numbers.
From those I need to include only those records which starts with Alphabets. i.e. the first character should be the Alphabet. |
You can use any one of the before posted codes which has the INCLUDE COND=... |
|
| Back to top |
|
|
|
|
|
