can you help me please

UKlee

Hi everyone I was wondering, I use some software that exports information fro a game to sql for storage via a normal post.

however it enters the informaion as follows ,numbers then letters for example 10000lbs.

I would like for this information to be added to another table in my database,but this has been set as simply numbers and there is no way I can change this now.

So what Im asking is how do I strip off the txt inorder to leave only the numbers before its posted to the database for storage.

so the item posted would be 10000 without the lbs on the end

thanks for looking

Lee

Houdini

Just use a preg_replace, I took your example that you can test the code with and apply to your situation.

<?php 
$string = '10000lbs';
$pattern= "#[a-zA-Z)]#i";
$replace= "";
echo preg_replace($pattern,$replace,$string);
?>

PHP Manual preg_replace()

BobLennon

Perhaps a less sophisticated technique would be:

$string = (int) '10000lbs';

UKlee

Yep thanks Bob I am also wondering how I would replace a comma with a decimal Point any ideas.

regards

lee

BobLennon

UKlee wrote:
Yep thanks Bob I am also wondering how I would replace a comma with a decimal Point any ideas.

regards

lee

IMHO the best tool for that job has already been suggested by Houdini -- a simple regular expression.