Re: String question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Chris Payne wrote:
Hi there everyone,



I am having to read a string with text in, but the way the DB is written in
the same string you have the price, for example”

this doesn't sound like a DB problem, sounds more like a regexp problem. (i.e. php-db is probably the wrong list)




CASARON 4G

50lb Sacks in Ton Lots

$88.00



How can I strip out the 88.00 (Baring in mind it could be any number)  into
it’s own string?

http://nl2.php.net/manual/en/ref.pcre.php

NB: note the difference between using single and double quotes when
defining your regexp. e.g:

$regexp = '/^.*\$[ \t]?([0-9]+\.[0-9]{2})$/s';

and:

$regexp = "/^.*\$[ \t]?([0-9]+\.[0-9]{2})$/s";

...are not the same.

assuming that the price is at the end of the string you and is preceeded by a dollar sign (with or without a seperating space) could do:

<?php

$myString = "
CASARON 4G
50lb Sacks in Ton Lots
$88.00
\r\n
\t\r\n
";

$matches = array();
$found = preg_match(
           '/^.*\$[ \t]?([0-9]+\.[0-9]{2})$/s',
           /* some commented out alternatives */
	   // '/^.*\$([0-9]+\.[0-9]{2})$/s',
           // '/^.*\$([0-9]+\.00)$/s',
           // '/^.*\$(88\.00)$/s',
           // '/.*\$(\d+\.\d+)/s',
           trim($myString), /* make life easier have a trim */
           $matches /* passed by ref */
           );


print_r("original string:\n--\n$myString"); print_r("\n\ntrimmed string:\n--\n".trim($myString)."\n\n");

print_r("found: $found\n matches array contents:\n\n");
print_r($matches);

?>




Thank you.



Chris


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.816 / Virus Database: 554 - Release Date: 12/14/2004



-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux