View previous topic :: View next topic
|
Author |
Message |
rmaruri
New User
Joined: 29 Jun 2005 Posts: 13 Location: USA
|
|
|
|
Can you tell me UNSTRING command for the below requirement?
Input: 5,00,000
Output: 500000
Requirement: remove the commas.
I have used the below code. my output is showing as 5 00 000. i am getting spaces. I have to delete this as well.
UNSTRING WS-STRING-INT-1
DELIMITED BY ','
INTO WS-STRING-INT-2
END-UNSTRING
please help me. |
|
Back to top |
|
|
Raghu navaikulam
Active User
Joined: 27 Sep 2008 Posts: 193 Location: chennai
|
|
|
|
Hi rmaruri
Please provide the picture clause of the 2 variables
WS-STRING-INT-1
WS-STRING-INT-2.
Regards
Raghunath |
|
Back to top |
|
|
donevin
New User
Joined: 07 Jun 2005 Posts: 70 Location: South Africa
|
|
|
|
If you want the numeric value of the string, 'cause it seems to me that's what you want, you can get it this way :
Code: |
COMPUTE WS-STRING-INT-2 =
FUNCTION NUMVAL-C (WS-STRING-INT-1).
|
but keep in mind that WS-STRING-INT-2 must be numeric. If you want the string value, move the numeric value to the string field again. |
|
Back to top |
|
|
rmaruri
New User
Joined: 29 Jun 2005 Posts: 13 Location: USA
|
|
|
|
It worked. Thanks a lot donevin. |
|
Back to top |
|
|
donevin
New User
Joined: 07 Jun 2005 Posts: 70 Location: South Africa
|
|
|
|
You're welcome. I have received lotsa help on the forums so I'm very glad I can give some back. |
|
Back to top |
|
|
|