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

[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

[Alecsandra · Accepted solution]

Hi Vasilis,

This activity is usually performed in HCI.

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

Best

Alecsandra

[Former Member · Accepted solution]

Thank you very much Alecsandra for your answer.

Best regards

Vasilis