Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Removing zeros in front of a string

 
igwe kalu kalu ogba
Ranch Hand
Posts: 133
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 92
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1923
Linux Postgres Database Scala
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I guess he means only to suppress some of the Zeros:

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

printf or regexp could help:



[ 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
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!