Skip to Content
0
Former Member
Jun 21, 2015 at 01:49 PM

Need help in LPAD for numeric val in calculated column

1082 Views

Hi ,

I have a requirement to write a logic in calculated column to apply padding to kunnr ,if kunnr value is non numeric else add 20 char padding .

syntax Used : lpad("KUNNR",strlen("KUNNR")+10,'0')

this is adding padding but how to check kunnr is numeric or string before adding padding