IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Case insenstive in INCLUDE Condtion


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
smileseenu

New User


Joined: 27 Sep 2006
Posts: 13
Location: India

PostPosted: Mon Feb 15, 2016 8:42 pm
Reply with quote

Dears,

In the input file we have,

Test
TEST
test
exclude


I am trying to extract using Include condition in SORT all records with "Test" (3 records) in position1
Back to top
View user's profile Send private message
Garry Carroll

Senior Member


Joined: 08 May 2006
Posts: 1109
Location: Dublin, Ireland

PostPosted: Mon Feb 15, 2016 9:35 pm
Reply with quote

Code:
 INCLUDE COND=(1,4,CH,EQ,C'TEST',OR,
               1,4,CH,EQ,C'TESt',OR,1,4,CH,EQ,C'TEsT',OR,
               1,4,CH,EQ,C'TeST',OR,1,4,CH,EQ,C'tEST',OR,...


... and keep going until you've covered every combination. If the file is VB, alter the position accordingly.

Garry.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

PostPosted: Mon Feb 15, 2016 9:50 pm
Reply with quote

if you are up-to-date:

"Alphanumeric comparison tests
New UC, LC, MC, UN, LN and MN keywords (similar to the previously available
NUM keyword) now allow you to test a field for various combinations of
alphanumeric characters or non-alphanumeric characters using binary (BI) format.
The new keywords allow you to select any of the following alphanumeric
character sets:
v UC: Uppercase characters (A-Z)
LC: Lowercase characters (a-z)
MC: Mixed case characters (A-Z, a-z)
UN: Uppercase and numeric characters (A-Z, 0-9)
LN: Lowercase and numeric characters (a-z, 0-9)
MN: Mixed case and numeric characters (A-Z, a-z, 0-9)
You can use these new keywords in the following comparison operands: COND,
INCLUDE, OMIT, BEGIN, END, WHEN and TRLID."

There are similar new options for starting and ending PARSE.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts INCLUDE COND with WHEN=GROUP SYNCSORT 12
This topic is locked: you cannot edit posts or make replies. include and copy COBOL Programming 4
No new posts include cond ascii constant DFSORT/ICETOOL 4
No new posts Required Date Format in Include Sort ... DFSORT/ICETOOL 6
No new posts SMF Specify in the INCLUDE parameter ... DFSORT/ICETOOL 7
Search our Forums:

Back to Top