Skip to Content
0

How to get rid off leading zeros in the excel addin palnning views

Oct 18, 2016 at 12:21 PM

130

avatar image
Former Member

Dear community,

The product id is transfered to our ibp system from ECC. It contains leading zeros that we would like to get rid off them in the excel addin planning views. Would that be possible somehow?

Thank you for your time

Best regards

Vasilis

nlxhn.png (5.8 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Alecsandra Dimofte
Oct 18, 2016 at 12:25 PM
0

Hi Vasilis,

This activity is usually performed in HCI.

Check ltrim function and use it in the mapping of product id.

Best

Alecsandra

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you very much Alecsandra for your answer.

Best regards

Vasilis

0