View previous topic :: View next topic
|
Author |
Message |
anandinmainframe
Active User
Joined: 31 May 2007 Posts: 171 Location: India
|
|
|
|
Hi All,
Is there any Function to find Special Characters in a String in Easytrieve.
For eg: First Name is Anand$
Last Name is Murugesan%
here i want to verify each and every character whether it is an alphabet(Capital or small) or spaces. if it is Alphabets or spaces then i dont want them if it is special character then i need those records.
First Name starts at 10 length 30
Last Name starts at 20 length 40 |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
It might help if you told us which of the CA products that you are using, or planning to use. |
|
Back to top |
|
|
anandinmainframe
Active User
Joined: 31 May 2007 Posts: 171 Location: India
|
|
|
|
Expat,
I am using CA-EASYTRIEVE PLUS-6.3 version. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Easytrieve 6.3 is way out of date. . . It is also out of support. . .
To do what you want, make an array of the "good" values (letters, spaces - numerics?) and compare each character (make this an array also) of the "input" to that array. |
|
Back to top |
|
|
anandinmainframe
Active User
Joined: 31 May 2007 Posts: 171 Location: India
|
|
|
|
Dick,
Thanks for the response. I declared group variables and checked each and every character. it worked. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
You're welcome
Good to hear it is working - thanks for letting us know.
d |
|
Back to top |
|
|
kratos86
Active User
Joined: 17 Mar 2008 Posts: 148 Location: Anna NGR
|
|
|
|
Hi expat,
Is there any option available in CA-EASYTRIEVE PLUS-6.4 version. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
The solution above will work for 6.4 also.
I know of no built-in Easytrieve function. |
|
Back to top |
|
|
|