topic Re: Truncating Numeric Field in Application Development and Automation Discussions

Truncating Numeric Field

Former Member — Mon, 17 Mar 2008 11:17:40 GMT

Hi all,

i want to truncate extra spaces from salary field...can anyone help me with the code?

i can do it if it is a string.but how i will do with integers???

Merlin

Re: Truncating Numeric Field

Former Member — Mon, 17 Mar 2008 11:21:01 GMT

Your solution will likely be to move the field to a string field for display and/or manipulation.

Re: Truncating Numeric Field

Former Member — Mon, 17 Mar 2008 11:23:25 GMT

Hi,

Better move it to a char/string type field and condense.

reward if helpful.

Regards,

ramya

Re: Truncating Numeric Field

Former Member — Mon, 17 Mar 2008 11:25:05 GMT

do this way ...


data : v_inte type i value '100 01',
         v_char(10),
         v_final type i.

 v_char = v_inte.
condense v_char no-gaps.
v_final = v_char.
write v_final.

Regards,

Santosh

Edited by: Santosh Kumar Patha on Mar 17, 2008 4:56 PM