removing comma from numeric data

[gfrank]

I know there is a function in php to take a numeric variable and add decimals and/or commas (for the thousands) when printing out a number...

is there a function that REMOVES thousands place commas from a piece of data in a variable?

I have a CSV file that is tab delimited, but some of the items in the file with quantities over 999 have numbers with commas in the thousands places...

how can I easily remove the commas so that 1,500 reads as 1500 when I store it in the database after pulling it from the csv?

although now I am wondering if the whole number is coming into the data with the comma or not. I am parsing it with a tab delimiter... and there are double quotes around the quantities with commas in them...

hmmm

[webdes03]

$variable = str_replace(",", "", $variable);

That should work. The only thing I'm not sure is the ,... thats the HEX code for the comma. I think if you actually put a comma in for that parameter you'll get a parse error, but if the above doesn't work, try just putting a comma in for the first field.

Additonal Function Info

[python_q]

Oops, posted my answer right after yours. You can just put comma in the version of PHP I'm using (4.3.4), since it's not a special character or anything. The , is the HTML code, and will not work so far as I know. The hex code for comma is 2C, and you have to put \x2C for it to work.

[webdes03]

Well there you go gfrank... guess you're all set. Thanks for clearing that up python_q, I wasn't sure about that.

[gfrank]

Thanks!

I'll give that a try. I just hope that the getcsv() command I am using is actually capturing the whole piece of data properly (with the comma) so I can parse the comma out... if it is stopping at the comma, Then I might have another problem!

;-0

[gfrank]

I have tried all these variations of the function... and keep getting a parse error...

$quant=str_replace(",","",$quant);

$quant=str_replace("\x2C","",$quant);

$quant=str_replace("2C","",$quant);

all generate a parse error... what am I doing wrong in the syntax?

[python_q]

In the code you posted, you have underscores between each argument. I don't know if that's in your actual code, but if it is, then that maybe is causing the error.
$quant = str_replace(",","",$quant); should work.

[gfrank]

argue!

yeah that was it... thanks!

[Drakla]

While we're on the comma thing - can anybody think of a dead easy/natty solution to this sort of problem.

I've written a Mime attachment email type thing, and you can pass in an argument in the constructor for to, cc, bcc with the addresses separated with commas, just like most email things. I then explode them into an array.

But if I get:

"Dr Spork, I am genius!" <[e-mail]>

as one of the addresses it clearly causes havoc. Any simple way of doing the 'am I a comma within quotes' thing? If the only way is counting the in/out thing with the quotes and there's not an easy solution just say so, as I don't want anyone to waste time coding something I should be doing.

cheers me dears.