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.
Field1 = 'CAL_0000138171_XYZ'.
split field1 at '_' into a b c.
SHIFT b LEFT DELETING LEADING '0'.