Removing zeros in front of a string

[igwe kalu kalu ogba]

Hi, I have a question:
I'm retrieving values from a database and getting a number like 23 outputted as 00000024, It varies.
My question is, how can I remove the first x zeros from a number. Can any of the numberformat tools help? Thanks.

[Cathy Song]

Something like this perhaps?

class a{
public static void main (String args[]){

String test = "0000024";
Integer i = new Integer (test);
System.out.println (i);
int num = i.intValue();
System.out.println (num);
}
}

[Stefan Wagner]

I guess he means only to suppress some of the Zeros:

000000042
....00042 (x=4).

printf or regexp could help:

public void printfTrim (String number, int x)
{
int len = number.length () - x;
String formatString = "Number %1$s with %2$d 0s suppressed: %3$0" + len + "d\n";
int value = Integer.parseInt (number);
System.out.printf (formatString, number, x, value);
}
 
public void regexTrim (String number, int x)
{
String trun = number.replaceAll ("\\b0{" + x + "}", "");
System.out.println ("Number " + number +" with " + x + " 0s suppressed: " + trunc);
}

[ August 04, 2005: Message edited by: Stefan Wagner ]

[ August 04, 2005: Message edited by: Stefan Wagner ]
[ August 04, 2005: Message edited by: Stefan Wagner ]

[Dharmesh Gangani]

You can get the data truncated from the database query as well. this removes a few lines of code.

Eg. If you want to truncate the value from the database to say 2 leading zeros' (0024), u can use the database query as -

select to_char(<col_name>, '0099') from <table_name>

The tow 0's indicate the number of leading zero's required & the 9's indicate the fixed number of digits required.

Hope this solves your purpose.
In case you have any further queries, please feel free to ask.