[SOLVED] CSV string to integer

[gevans]

Hey guys,

 

I'm currently working on a csv importer.

 

The importer works fine, and one of the pieces of data is a number, currently it's 1,516 (it can be anything from 0 up)

 

I need to save this number as an integer, as you'd imagine setting it to an integer loses the numbers after the thousands' comma;

 

$foo = "1,516";
echo (int)$foo;// outputs 1

 

What's the best way to strip the comma out?

[mtoynbee]

$foo = "1,516";
$foo = eregi_replace(",","",$foo);

[gevans]

Does eregi_replace take longer than str_replace?

 

I'm currently using str_replace, just wanted to see if there was anything better.

[mtoynbee]

I think str_replace might be slightly quicker.

 

ereg_replace is quicker than eregi as it's case insensitive. The difference is minimal though.

 

If you are using str_replace already does that not strip the comma?

[mtoynbee]

You can just use number_format

 

http://uk.php.net/number_format

 

 

[premiso]

Looks like str_replace would be the way to go or ereg_replace (gathered this from reading the comments on int type-casting). Either will work.

 

EDIT:

Source for more information

http://us.php.net/manual/en/function.intval.php#76803

 

Also removed number_format after reading it does not take strings for a param.

[gevans]

Yes it does, just wanted to see what my other options were. Number Format won't do it, it takes an ineger to be formatted not a string to reformat as an integer.

[premiso]

Yes it does, just wanted to see what my other options were. Number Format won't do it, it takes an integer to be formatted not a string to reformat as an integer.

 

After reading the comments it seems only the replace functions are your options...well other than using explode then implode which would be silly to do, but an example of that is:

 

<?php
$string = "123,423,234";
$int = (int) implode("", explode(",", $string));

echo $int; // should output 123423234
?>

 

=)

[gevans]

Haha, yes that is slightly overkill!!

 

Think I got it right the first time, I do love trying to run things faster though so always worth an ask!