topic Re: replace in Application Development and Automation Discussions

replace

Former Member — Wed, 23 Jul 2008 09:38:26 GMT

Hi Experts,

34.567.678.78,45

In above value I have to replace ' . ' with ' , ' and ' ,' with ' . '.

please do the need full help.

Thanks in advance,

Radhakrishna.

Re: replace

Former Member — Wed, 23 Jul 2008 09:42:32 GMT

data:char(25) value '34.567.678.78,45'.

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

replace all occurrences of ',' in char with '&' .

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

replace all occurrences of '&' in char with '.' .

write: char.

Re: replace

GauthamV — Wed, 23 Jul 2008 09:42:44 GMT

hi,

in menu goto user profile - own data in defaults tab choose the decimal notation u required.

Re: replace

Former Member — Wed, 23 Jul 2008 09:43:18 GMT

Go to Syetem --> User profile --> owndata --> defaults(tab page) there in decimal notation fix what type of notation u want....

regards,

Sunil Kumar Mutyala

Re: replace

Former Member — Wed, 23 Jul 2008 09:43:34 GMT

Hi Radhakrishnan,

In the user profile change the decimal notation format..

Menu~~>system~~>User Profile~~->Own Data~~->Defaults

Decimal notation: 1,234,567.89

Regards,

Nisrin.

Re: replace

Former Member — Wed, 23 Jul 2008 09:44:55 GMT

first split your variable at ',' and

split v_amount at ',' into v_amount1 v_amount2.

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

then concatenate both separated by '.'

concatenate

v_amount1 v_amount2 into v_amount separated by '.'

Re: replace

former_member217544 — Wed, 23 Jul 2008 09:46:32 GMT

Hi,

Firts replace ',' with another variable say ' # '

now replace '.' with ','

and then replace ' # ' with ' . '

Hope this will help.

Regards,

Swarna Munukoti.

Re: replace

Former Member — Wed, 23 Jul 2008 09:51:25 GMT

Hi Radhakrishna,

V1 = 34.567.678.78,45

In this context,

One way in using replace statement,

REPLACE ALL OCCURENCES OF '.' IN V1 WITH ' ,'.

REPLACE ALL OCCURENCES OF ',' IN V1 WITH '.'.

Prasad G.V.K