HI EXPERTS,
Field1 = CAL_0000138171_XYZ
Hw to delete zeros between CAL_ and XYZ.
ie output should be FIELD1 = CAL_138171_XYZ.
if FIELD1 = 0000138171
I can use this SHIFT FIELD1 LEFT DELETING LEADING '0'.
But hw to do first one.
Please help me.