Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Deleting Zeros

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.

Tags:
replied

data: field1(30).

Field1 = 'CAL_0000138171_XYZ'.

data: a(4),

b(20),

c(10).

split field1 at '_' into a b c.

SHIFT b LEFT DELETING LEADING '0'.

Rajneesh Gupta

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question