topic Re: Adding preceeding zero to the output in Application Development and Automation Discussions

Adding preceeding zero to the output

Former Member — Wed, 16 Apr 2008 09:26:26 GMT

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 — Wed, 16 Apr 2008 09:29:03 GMT

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 — Wed, 16 Apr 2008 09:30:33 GMT

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 — Wed, 16 Apr 2008 09:36:50 GMT

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 — Wed, 16 Apr 2008 10:31:11 GMT

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 — Wed, 16 Apr 2008 10:31:27 GMT

create one variable as char

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

regds

Former Member — Wed, 16 Apr 2008 10:33:32 GMT

Hi,

Please use FM CONVERSION_EXIT_ALPHA_INPUT.

Thanks,

Sriram Ponna.