Remove leading zeroes if it is number
Hi,
In the message mapping, idoc to structure,
idoc field of type CHAR, length 10.
possible values in this field are:
1003
PD01
both alphanumeric. Value will be always 4 characters max.
if it is numeric, ex:1003, it is showing with leading zeroes as,
0000001003. But i have to send only 1003, without leading zeroes.
if it is alphanumeric, no issue, it is always left justified & shows only PD01.
i tried to use arithmetic function, ROUND, this is ok for numeric values, but, data will be both. Even i can not use substring, bcoz, numeric value is right justified & alphanumeric is left justified.
If it has to solve by any UDF, plz share the code & the steps to fulfill the same with screen shot if possible.
tnx n rgds,
balu