Skip to Content
0
Sep 25, 2008 at 05:07 AM

Deleting Zeros

31 Views

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.