topic Re: split and concotenate in Application Development and Automation Discussions

split and concotenate

Former Member — Mon, 28 Jul 2008 07:50:42 GMT

hi huys,

how to split the value and concotenate the value...

for eg.

i hvave the value like 4.549,50 but i want 4,549.50 like this.

Thanks & Regards,

praveen

Re: split and concotenate

matt — Mon, 28 Jul 2008 08:50:10 GMT

Why not use REPLACE?

matt

Re: split and concotenate

prasanth_kasturi — Mon, 28 Jul 2008 09:07:34 GMT

HI,

try this way

PARAMETERS p_val(10) type c .

REPLACE ALL OCCURRENCES OF ',' in p_val with '.'.

replace '.' IN P_VAL WITH ','.

write p_val.

regards

prasanth

Re: split and concotenate

Former Member — Mon, 28 Jul 2008 09:19:57 GMT

First try to change the user settings in SU01.

Here in Default tab define decimal notation as 1,234,567.89.

and check whether changes are reflected or not?

After that also if you are getting the same problem then try the code

data : text(50) value '1.234,56'.

replace all occurrences of ',' in text with '*' .

replace all occurrences of '.' in text with ',' .

replace all occurrences of '*' in text with '.' .

write : / text.

Re: split and concotenate

Former Member — Mon, 28 Jul 2008 10:43:01 GMT

Hi,

You can use the following code for this,

DATA: str1 TYPE string,

str2 TYPE string,

str3 TYPE string,

itab TYPE TABLE OF string,

text TYPE string,

l_no type String value '4.549,50' .

SPLIT l_no AT '.' INTO: str1 str2 .

SPLIT str2 AT ',' INTO: str2 str3 .

concatenate str1 str2 into str2 separated by ',' .

concatenate str2 str3 into str3 separated by '.' .

write /: str3.

You can do this by using REPLCE also

replace all occurences of ',' in l_no with '.'.

replace first occurence of '.' in l_no with ','.

write : l_no.

Re: split and concotenate

Former Member — Tue, 29 Jul 2008 07:00:11 GMT

Hi prasad,

my problem is solved while going to the su01 transcaction.

thanq for ur help.

Regards,

praveen.