on 11-05-2007 8:09 AM
Hi
i want to display the format coming in 55,192 to 55.192,.
kindly suggest.
You can use the translate statement to change DOT's to COMMA's
Check this sample code
select single * from USR01 where BNAME = SY-UNAME.
case USR01-DCPFM.
when 'X'.
translate L_QNTY1 using ',.'.
translate L_QNTY2 using ',.'.
when ' ' .
translate L_QNTY1 using '.,'.
translate L_QNTY2 using '.,'.
when others.
Regards
Gopi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
u can use <b>replace all occurences of</b> statement
hope it helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
For changing the format you have to change the country code to 'DE'.
The relevent field is as given.
vbpla-land1 = 'DE'.
This will change the output in the script as you desire.
Deserve Reward.
regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.