PHP - cut everything before and after price in a string

Question

I got strings like these:

Test 120,00 Euro yaddayadda
200 € with 18 months of blablabla
3.000,65 € something . And here s something more with 0815. And more.
1 Euro
Last item for 5.234.789,00 Euro.

and I want to get rid of everything except the price. So with these examples it should be

120,00
200
3.000,65
1
5.234.789,00

I already got

preg_replace("/[^0-9,.]/", "", $string);

but that ain't enough. It turns

3.000,65 € something . And here s something more with 0815. And more.

into

3.000,65.0815..

Close...but still not enough.

Thx!

Instead of trying to replace, use `preg_match_all` to extract what you want. — Casimir et Hippolyte, Mar 30 '15 at 13:34
See [**Extract numbers from a string**](http://stackoverflow.com/a/6278312/1407478) — davidkonrad, Mar 30 '15 at 13:36

anubhava · Accepted Answer · 2015-03-30T13:42:14.610

2

You can use:

$result = preg_replace('/^\D*(\b\d+([,.]\d+)*\b).*$/m', '$1', $str);

RegEx Demo

This regex:

\D*           # matches all non-digits from start
\b            # word boundary
\d+([,.]\d+)* # matches your floating point number in each line
(...)         # groups these numbers
.*$           # match rest of the line

And replacement is $1 which is captured number.

edited Mar 30 '15 at 13:42

answered Mar 30 '15 at 13:36

anubhava

761,203
64
569
643

1

I think an explanation for OP and further readers would be helpful what the regex exactly does – Rizier123 Mar 30 '15 at 13:39
3

Awesome, that did the trick. However that's one hell of a preg_replace...do you got some kind of explanation for Future Me? :) – TZP Mar 30 '15 at 13:40
Yes I've just added an explanation and besides my demo link also has a great explanation of this regex. – anubhava Mar 30 '15 at 13:42
1

And the `/m` turns on multiline mode. – Sean Bright Mar 30 '15 at 13:42

PHP - cut everything before and after price in a string

1 Answers1