AJAYREDDY
New User
Joined: 17 Feb 2007 Posts: 52 Location: USA
|
|
|
|
I have a file with 404 FB length. At position 223 length 5 there are some non-numeric values. example spaces, G, T, A etc etc. I want to replace them with Zeros if they have any. Can we do this with IFTHEN and OVERLAY statements. How do we declare non-numeric value in IFTHEN clause?
Example: If input at position 223 has below values
Code: |
12345
50G00
19673
70L00
00355
90G00
00 00
00L00
|
The output should be
Code: |
12345
50000
19673
70000
00355
90000
00000
00000
|
Please note: The non-numeric can be anything Alphabetic/spaces. |
|