Hello, I would like to add zero before a field. For example ...

[Guilaine Pertel]

Hello, I would like to add zero before a field. For example , I have Customer number : 1234, and I would like all customer number in 10 digits with zero before.

[David Beagan]

If your field is a numeric data type then you can create a Compute with the L format:

TABLE FILE ibisamp/ggsales

PRINT SEQ_NO

COMPUTE SEQ_NO_LZ/P10L = SEQ_NO;

END

[Guilaine Pertel]

No, the field is a Alpha data.

`TABLE FILE EMPLOYEE

PRINT EMP_ID

COMPUTE EMP_ID1/A15 = EMP_ID;

WHERE RECORDLIMIT EQ 2

END

Im waiting :

EMP_ID EMP_ID1

071382660 000000071382660

112847612 000000112847612

`

[David Beagan]

Perhaps there is something simpler, but this works:

TABLE FILE ibisamp/employee

PRINT EMP_ID

COMPUTE EMP_A15/A15 = EMP_ID;

COMPUTE EMP_RJ/A15 = RJUST(15, EMP_A15, 'A15');

COMPUTE EMP_RP/A15 = REPLACE(EMP_RJ, ' ', '0');

ON TABLE SET STYLEMODE FIXED

WHERE RECORDLIMIT IS 2

END

[Michel Pageau]

Much simpler:

TABLE FILE ibisamp/employee

PRINT EMP_ID

COMPUTE EMP_ID_LZ/P15L = EDIT(EMP_ID); NOPRINT

COMPUTE EMP_ID1 /A15 = EDIT(EMP_ID_LZ);

IF RECORDLIMIT IS 2

END

[Guilaine Pertel]

Thank you very much.

[David Beagan]

Very good, much simpler.