|
View previous topic :: View next topic
|
| Author |
Message |
Abi
New User
Joined: 27 Jul 2005
Posts: 35
Location: Chennai
|
|
|
|
I have a aplhanumeric field of length 20. Actaully it shld contain only numeric field...but in the database it has non numeric values...
So before processing i need to check for numeric values.If it contain any non-numeric values i need to replace it with numeric values.
WS_VARIABLE X(20)
Can i check for if ws-variable is numeric ?
2. Also in my previous topic i have asked how to convert non-numeric values to numeric and i got the answer of using UNSTRING
But if the filed has values like
222-222-222
22 2222-222
how can i use unstring ? |
|
| Back to top |
|
 |
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi ABi,
| Quote: |
So before processing i need to check for numeric values.If it contain any non-numeric values i need to replace it with numeric values.
WS_VARIABLE X(20)
Can i check for if ws-variable is numeric ? |
Ya u can check
| Code: |
| IF WS_VARIABLE IS NUMERIC |
|
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
Hi Abi
I think you shoud go character by character and check if it is numeric and move only the numeric digits to an output field. If there is any other possibility please let me know.
Thanks
Arun |
|
| Back to top |
|
|
|
|
