How to add leading zeroes in xslt mapping

[sateesh_adma]

Hello All,

We have a requirement of  adding leading zeroes to a number in xslt mapping.

We tried like this but it's not working

<ns0:when test="$kunnr-length &gt;0">

<ns0:value-of-select="substring(../../KUNNR,1,4)"/>

<ns0:value-of-select="formatnumber(12345678,'00000000')"/>

Any ideas how to do this.

Thanks,

Sateesh

[former_member190293]

Hi Sateesh!

Maybe I don't get your requirement exactly, but why not to just concat "0000" and your substring?

Regards, Evgeniy.

[Snavi]

Hi Sateesh,

try with below statement

<xsl:value-of select="format-number(substring(../../KUNNR,1,4),'00000000')"/>

[former_member186851]

Hello Sateesh,

Try like below

<ns0:when test="$kunnr-length &gt;0">

<ns0:value-of-select="substring(../../KUNNR,1,4)"/>

<ns0:value-of-select="format-number(12345678,'00000000')"/>

[sateesh_adma]

We have already tried same code..

my requirement is like if kunnr value is like 12345678

We need to take first 4 characters for that we used substring and getting value as 1234

after that we need to add 4 leading zeros to it

so final output should be 00001234

[former_member186851]

see - missed in format number..Try with it ,if its working let us know.

[sateesh_adma]

yes we tried with - only, that was a typo when raising question

thanks