Remove non-numeric characters except periods and commas from a string

Question

If I have the following values     var1   AR3 373 31    var2   12 322 11T   How can I create a new variable and set it to a copy of the data that has any non-numeric characters removed  with the exception of commas and periods  The values above would return the following results     var1 copy   3 373 31    var2 copy   12 322 11

User · Answer

If letters are always in the beginning or at the end  you can simply just use trim   no regex needed   string   trim  string   a  zA  Z       this also take care of lowercase   AR3 373 31  -- gt   3 373 31   12 322 11T  -- gt   12 322 11   12 322 11   -- gt   12 322 11

User · Answer

You could use filter var to remove all illegal characters except digits  dot and the comma    The FILTER SANITIZE NUMBER FLOAT filter is used to remove all non-numeric character from the string  FILTER FLAG ALLOW FRACTION is allowing fraction separator       The purpose of FILTER FLAG ALLOW THOUSAND to get comma from the string      Code   var1    12 322 11T    echo filter var  var1  FILTER SANITIZE NUMBER FLOAT  FILTER FLAG ALLOW FRACTION   FILTER FLAG ALLOW THOUSAND     Output  12 322 11     To read more about filter var   and Sanitize filters

User · Answer

Simplest way to truly remove all non-numeric characters   echo preg replace    D         string      D represents  any character that is not a decimal digit   http   php net manual en regexp reference escape php

User · Answer

You could use preg replace to swap out all non-numeric characters and the comma and period full stop as follows   testString    12 322 11T   echo preg replace     0-9             testString    The pattern can also be expressed as     d

User · Answer

I m surprised there s been no mention of filter var here for this being such an old question     PHP has a built in method of doing this using sanitization filters  Specifically  the one to use in this situation is FILTER SANITIZE NUMBER FLOAT with the FILTER FLAG ALLOW FRACTION   FILTER FLAG ALLOW THOUSAND flags  Like so    numeric filtered   filter var  AR3 373 31   FILTER SANITIZE NUMBER FLOAT      FILTER FLAG ALLOW FRACTION   FILTER FLAG ALLOW THOUSAND   echo  numeric filtered     Will print  3 373 31    It might also be worthwhile to note that because it s built-in to PHP  it s slightly faster than using regex with PHP s current libraries  albeit literally in nanoseconds

[php] Remove non-numeric characters (except periods and commas) from a string

Examples related to php

Examples related to string