preg_match decimals

bookbuyer2000

Hi, I've been working on this for 8 days :glare: and still cannot figure out how to take an array of numbers (consisting of a line-by-line pricelist) and then to:

a.) extract just the numbers (including decimal numbers)
b.) remove the duplicates on each line
c.) add a duplicate if only decimal is present
d.) put the result in a new comma-delimited array

Example:
3 widgets at $0.50 each = $0.50
2 widgets at $5.00 each = $5.00 ($2.00 if small widget)
11 widgets at $2.00 each = $2.00
1 widget at $12.01 each = $12.01 ($6.00 if widget is missing wheels)

Desired "extraction":
3,0.50,0.50 // added a duplicate
2,5.00,2.00
11,2.00,2.00 // added a duplicate
1,12.01,6.00

To me, this has been excruciatingly complicated -- but no doubt (as always) there is probably a simple line of code to make this work 🙂

Kudose

That doesn't make sense with the example provided. You're not getting the product of the items correct.

Can you post the actual data you are working with?

nrg_alpha

Hmm.. admittedly, the OP's post is slightly confusing.. but here is what I came up with:

$str = <<<DATA
3 widgets at $0.50 each = $0.50
2 widgets at $5.00 each = $5.00 ($2.00 if small widget)
11 widgets at $2.00 each = $2.00
1 widget at $12.01 each = $12.01 ($6.00 if widget is missing wheels)
DATA;

preg_match_all('#^(\d+)[^$]+\$(\d+\.\d+).*(\d+\.\d+).*$#m', $str, $matches);
for($i=0; $i < count($matches[0]); $i++){
   echo $matches[1][$i] . ',' . $matches[2][$i] . ',' . $matches[3][$i];
      if($matches[2][$i] == $matches[3][$i]){
         echo ' // added duplicate';
      }
      echo '<br />';
}

Output:

3,0.50,0.50 // added duplicate
2,5.00,2.00
11,2.00,2.00 // added duplicate
1,12.01,6.00

But to get the results the OP has listed, I only take into account the last set of digits listed for the second set of reported digits / decimals. So yes, there is some backtracking in this solution, but seems to do the job in accordance to what the OP has listed.