topic Re: Doubt in Data Format in Application Development and Automation Discussions

Doubt in Data Format

Former Member — Mon, 11 Jun 2007 03:43:46 GMT

Hi All

I am reading a text filr using GUI_UPLOAD into my internal table. In That I have values like 25.00 and 234.0 . So i need it as 25 and 230. Give me a simple way to do this.

Thanks...

Re: Doubt in Data Format

Former Member — Mon, 11 Jun 2007 03:44:16 GMT

Not 230.Its 234.

Re: Doubt in Data Format

Former Member — Mon, 11 Jun 2007 03:45:33 GMT

Hi,

Move the value to an interger data type field..To remove the decimals.

Thanks,

Naren

Re: Doubt in Data Format

Former Member — Mon, 11 Jun 2007 03:47:23 GMT

Thnks Naren

Any other way to delete Only This Zeros....

Re: Doubt in Data Format

Former Member — Mon, 11 Jun 2007 03:48:59 GMT

Hi,

When you import all the data, you might used 'char' format in the internal table field, but later you move to integer format variable...so it can take only till decimals.

Regards,

donepudi

reward, if its useful

Re: Doubt in Data Format

Former Member — Mon, 11 Jun 2007 04:21:07 GMT

If i am moving to Integer format i will loose all decimals right. I need to avoid valuse if it contais only '0' after decimal part.

for eg 23.00 i dont want.

but 23.56 i want this value like this only..

Can anyone give a better idea..........

Re: Doubt in Data Format

Former Member — Mon, 11 Jun 2007 04:21:46 GMT

Declare the data type as integer for the fields of internal table for which you want such type of conversion.

Reward points if helpful.

Re: Doubt in Data Format

Former Member — Mon, 11 Jun 2007 05:04:11 GMT

Hi All

Waiting For ur reply..Is there any option to delete zero;s that is coming after decimal numbers..

Eg: 25.30.. I need it as 25.3.

and 23.00 i need it as 23.

Is there any option.........

Re: Doubt in Data Format

Former Member — Mon, 11 Jun 2007 05:20:12 GMT

hi scorpio,

define one variable with data type p,

ex: data: l_no type p.

move ur field into this variable (l_no),

then it gives as 25 or 234.

regards,

seshu.

Re: Doubt in Data Format

dev_parbutteea — Mon, 11 Jun 2007 05:50:45 GMT

Hi Scorpio,

try this

data: varpp TYPE p LENGTH 6 DECIMALS 4 VALUE '32.0000'.

data: varp2 TYPE p LENGTH 6 DECIMALS 4 VALUE '32.6500'.

data: varp3(7) TYPE c .

data: vari1 TYPE i,

vari2 TYPE i,

vari3 TYPE i.

varp3 = varpp <b>(or varp2).</b>

vari1 = STRLEN( varp3 ).

vari2 = vari1.

do vari1 times.

vari3 = vari2 - 1.

if varp3+vari3(1) ca '.0'.

varp3 = varp3+0(vari3).

else.

exit.

endif.

vari2 = vari2 - 1.

enddo.

WRITE 😕 'varp3 ' , varp3.

Regards,

Sooness.