• 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic