topic Re: field move in Application Development and Automation Discussions

field move

Former Member — Thu, 05 Jun 2008 10:13:47 GMT

Hi,

i have fields type char10 and i wont to move it to field type P dec2 i wont that the last to numbers be residue.

e.g.

char10

123456

p dec2

1234.56

i don't wont to use concatenate what is the best way to do that?

Regards

Re: field move

Former Member — Thu, 05 Jun 2008 10:24:19 GMT

hi,

I guess you got to use the conctenate statement to achieve the same ..

i.e,


data : v_char(6) value '123456',
         v_char_o(10),
         v_p type p decimals 2.

concatenate v_char+0(4) v_char+4(2) into v_char_o separated by '.'.

move v_char_o to v_p.

write : v_p.

Re: field move

Former Member — Thu, 05 Jun 2008 10:27:34 GMT

Hi Santosh Kumar Patha,

thanks but i don't wont to use concatenate maybe i can use MASK for this?

Regards

Re: field move

Former Member — Thu, 05 Jun 2008 10:33:08 GMT

hi,

But what is the problem that you are facing using concatenate statement ???

Regards,

Santosh

Re: field move

Former Member — Thu, 05 Jun 2008 10:40:32 GMT

Hi Santosh Kumar P... ,

i don't have any problem with concatenate but i wont to now if there is another way to do that and How?

Regards

Re: field move

peter_ruiz2 — Thu, 05 Jun 2008 10:41:41 GMT

hi cosmo,

try this


report test.

data:
  v_char(10) type c,
  v_dec type p decimals 2.

start-of-selection.
v_char = '123456'.

move v_char to v_dec.

divide v_dec by 100.

message i999(z0) with v_dec.

regards,

Peter

Re: field move

Former Member — Thu, 05 Jun 2008 10:48:42 GMT

hi,

Try Peter's answer to achieve the same ...

Regards,

Santosh

Re: field move

Former Member — Thu, 05 Jun 2008 11:01:28 GMT

Hi,

there is no way to do it with mask?

Regards

Re: field move

Former Member — Thu, 05 Jun 2008 11:36:19 GMT

Hi friends,

any idea if i can do it with musk ?

Regards

Re: field move

peter_ruiz2 — Fri, 06 Jun 2008 05:54:59 GMT

hi,

you can use this code

write v_char using edit mask '____.__'.

Note: This code has limitations. On this sample code, it is assumed that your string only contains 6 characters for display. If you have 7 characters, the last character is disregarded.

regards,

Peter