Regex to cut off currency and following

#1

Hello,

Here is the following example:
150,26 € * per item

I only need 150,26 without the "€ * per item"

I tried to solve it with ([^\s]+) €

But after webscaping, the column is filled with "null"

What did I do wrong?

Thank you in advance?

#2

If the data always starts with digits, this should be enough:
^[^\s]+

If not, something like this:
\d[^\s]+