Need help with a script.

[iPixel]

I need to write a script that will literally be ran just once, it's kidna like a fix i need to do in the database.

 

I have a field called filenumber which contains a number such as 002707 and many more like it.

all of them start off with zeros then the #'s. So employee # 1 would be 000001 and employee 1000 would be 001000. So you get get the idea.

 

I need to remove those initial 0's to turn 002707 into 2707, and the 001000 into 1000's.

 

here's how i invision this...

 

 

Select data from table

while results = fetch 

{

      take result[filenumber]

    use soem function to keep deleting zeros from left to right untill it hits a number other then 0.

   

    update the database row with the new filenumber. 

}

 

So i guess what i really need is a function that will allow me to parse through the filenumber string, and remove those zeros, up to a # other then 0.

 

 

Thanks!

[JonnoTheDev]

simple

<?php
$string = "00000123445";
$string = ereg_replace('^0{0,}', '', $string);
print $string;
?>

[iPixel]

Hah! Perfect! TYVM !