Hi,

I would like to replace 0 by the character '-' in my result.

I tried with this (POUR is I9):

APOUR/A9 = IF POUR EQ 0 THEN '-' ELSE EDIT(POUR);

The problem is that 0 appear like this:

218 becomes 000000218
5214 becomes 000005214
...

Is there a way to convert directlz my 0 in '-'?

This message has been edited. Last edited by: Jérény Deidda,

Try the CTRAN function

 TABLE FILE EMPLOYEE
PRINT ADDRESS_LN3 AND COMPUTE
ALT_ADDR/A20 = CTRAN(20, ADDRESS_LN3, 48, 45, ALT_ADDR);
BY EMP_ID
WHERE TYPE EQ 'HSM';
END
 

Use the CTRAN Function.

quote:

APOUR/A9 = CTRAN (9,POUR, 060, 055, APOUR;

Thanks but I become the same result :

25 ---> 000000025

OK I just understood, I changed my ASCII codes and it runs better ,-)

I would suggest using FTOA.

APOUR/A9 = IF POUR EQ 0 THEN '-' ELSE FTOA(POUR,'F9','A9');

Thanks,

the problem is solved with FTOA.

Topic must be closed and marked as solved.

quote:

Topic must be closed and marked as solved.

You are the only one who can do that (apart from the forum admin of course).
Go to your very first post and edit it. That will give you the opportunity to change the desription.