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
