Adding preceeding zero to the output

[Former Member]

Hi,

Please tell how to add preceeding zeroes to a particular field in the output of a report in an excel.

In internal table preceedings zeroes are coming but in the output preceeding zeroes are not populating.

regards

Ajay

[Former Member]

use FM conversion_exit_alpha_input

but in Excel leading zeros are not shown so you have either chane the type of excel file and make it tabdelimited

do reward if helpful

[Former Member]

Hi,

execl interprets the field as a number. put a littel quote ' before your field or tell excel it's a text field.

Regards, Dieter

[Former Member]

Hi,

CONVERSION_EXIT_ALPHA_INPUT converts any number into a string fill with zeroes, with the number at the extreme right

Example:

input = 123

output = 0000000000000...000000000000123

CONVERSION_EXIT_ALPHA_OUTPUT converts any number with zeroes right into a simple integer

Example:

input = 00000000000123

output = 123

Pls reward points if useful.

[Former Member]

create one variable as char

move this value to that variable and print that in output..hope this helps

regds

Edited by: sudheer sun on Apr 16, 2008 11:31 AM

[Former Member]

create one variable as char

move this value to that variable and print that in output..hope this helps

regds

[Former Member]

Hi,

Please use FM CONVERSION_EXIT_ALPHA_INPUT.

Thanks,

Sriram Ponna.