AnsweredAssumed Answered

PHP get field, is there a way to strip comma from results?

Question asked by Tom_Droz on May 3, 2017
Latest reply on May 4, 2017 by beverly

Hi

I have a php script that grabs data from fields in a hosted FileMaker solution.  Part of the code reads:

 

mysql_real_escape_string($inventory_row->getField('VEHICLES::Price
Asking'))

 

The problem is the field has values with a comma ie "10,000"  I want the results to be just the number no comma ie "10000"

 

Is there a way to do that within the above PHP code?

 

The data is from many databases so changing it there isn't my 1st option.  The data is scripted to be inserted in to a MYSQL database and it needs to be a number without a comma.  Any ideas on if the code above can be tweaked to accomplish this?

 

Thanks!

 

Tom

Outcomes