View previous topic :: View next topic
|
Author |
Message |
Ambili S
Active User
Joined: 06 Sep 2007 Posts: 112 Location: India
|
|
|
|
Hi
In the INCLUDE COND the basic syntax is (5,5,CH,EQ,C'ABDFE') i.e.
the value present in the position is given . I wanted to know if it is possible to check if the data in position 5 to 10 is numeric or character using INCLUDE COND. |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
You can use DFSORT's NUM function to determine if positions 5-10 are numeric or non-numeric:
For example, to include only records that are numeric, you can use this DFSORT statement:
Code: |
INCLUDE COND=(5,6,FS,EQ,NUM)
|
You can use NE,NUM to check for non-numeric.
For more information on NUM, see:
Use [URL] BBCode for External Links |
|
Back to top |
|
|
Ambili S
Active User
Joined: 06 Sep 2007 Posts: 112 Location: India
|
|
|
|
Murali, Frank
Thanks for the solution . |
|
Back to top |
|
|
|