Hi,
we are working on UDF to remove the leading zeros only for AlphaNumeric articles not for Numeric article numbers.
Leading zeros should not be removed for numeric article numbers -000000002298540051
Alphnumeric Material number
Input value as -00000000H000060004
Expected out - H000060004
Numeric Material number
Input value as - 000000002298540051
Expected out - 000000002298540051
UDF :
String b = var1.replaceFirst("^0*", "");
return b;
Please help in udf to remove leading zeros only Alphanumeric articles only.
Thanks in Advance
Ravi