Field with leading zeros

[shawnklar]

I have a (probably) simple problem:

In SAP, I have two tables. The first gives me the account number field (SAKNR) 10 digits, in the second between six and nine points.
I want the SAKNR field generally have 10 digits and leading zeros.
example:
0000628461
0000047933

not

628461

47933
I tried it with the num # statement, but that does not work somehow.

Can someone please help me?
Thank you.

Peter

[alexandros17]

write:

Repeat('0', 10 - len(SAKNR)) & SAKNR as SAKNR

Hope it helps

[CELAMBARASAN · Accepted solution]

Try with Num function

Num(SAKNR , '0000000000') AS SAKNR

Hope it helps

[jagan]

Hi,

Try like this

LOAD

Dim1,

Dim2,

Text(Repeat('0', 10 - len(SAKNR)) & SAKNR) as SAKNR

FROM DataSource;

Regards,

Jagan.

[MK_QSL]

Num(example,'0000000000') as example

[arjunkrishnan]

Hai Peter.

Try It This One

Num(SAKNR,'0000000000')

[shawnklar]

Thank you.

All of your solutions help me.

This is really a great community

Peter