Menu
Community /Pin to ProfileBookmark
@NogDogApr 27.2009 — #One way would be to simply replace anything that's not a number with nothing:
Another way would be to locate the underscore and take everything after it:
@NogDogApr 27.2009 — #If a character class (the stuff within square brackets) starts with a "^", that means to match on anything that does [b][i]not[/i][/b] match that character class (sort of like the PHP "!" negation operator).@NogDogApr 27.2009 — #For the record, there is, in fact, a slight difference between "D" and "[^0-9]", though it likely would not matter for this application:
Output:
[b]0123456789²³¹[/b]
Remove parts of value
Hi, Im having difficulty figuring this one out.
Im pulling values from a database, the values are numbers prefixed with a letter and an underscore. (eg: t_200)
How do I strip the value down to just the number?
Thanks in advance.
Sign in
to post a comment5 Comments(s) ↴
0
@NogDogApr 27.2009 — #One way would be to simply replace anything that's not a number with nothing:[code=php]
$numbersOnly = preg_replace('#[^0-9]#', '', $valueFromDB);
[/code]Another way would be to locate the underscore and take everything after it:
[code=php]
$numbersOnly = substr($valueFromDB, strpos($valueFromDB, '_') + 1);
[/code]0
@NogDogApr 27.2009 — #If a character class (the stuff within square brackets) starts with a "^", that means to match on anything that does [b][i]not[/i][/b] match that character class (sort of like the PHP "!" negation operator).0
@NogDogApr 27.2009 — #For the record, there is, in fact, a slight difference between "D" and "[^0-9]", though it likely would not matter for this application:[code=php]
<?php
$str = '';
for($i=1; $i<=255; $i++)
{
$str .= chr($i);
}
echo preg_replace('#D#', '', $str);
?>
[/code]Output:
[b]0123456789²³¹[/b]