deleting zeros

[Former Member]

Hi,

I need to remove both leading and zeros after the actual digit. 00100 should be 1.

I don't want to use UDF. is there any standard functions for this?

Regards

[Former Member · Accepted solution]

use replaceString function (if u want to delete both leading and trailing zeros)

[Former Member · Accepted solution]

Hi, Thanks for answers!

I solved it by using ReplaceString. in the first parameter I used the incoming data, 2nd parameter I put Constant '0' (the value I want to remove), and 3rd parameter I put in Constant 'blank' (the value I want to replace the '0' with.)

Thanks!

[Former Member]

You can use replaceValue function, and replace 0 with ''.

Here you can find the complete function list:

http://help.sap.com/saphelp_erp2004/helpdata/en/43/c4cdfc334824478090739c04c4a249/content.ht

[Former Member]

Hello,

But replaceValue("0","") would transform "10001" into "11" ? You could use the replaceFirst(String regex,String replacement) method from the String class ...

Rgds

Chris

[Former Member]

The ReplaceValue function only has one input parameter. So you can only replace the input parameter with a constant value. whereas the replace string you can define which value in the input parameter you want to replace.

Regards