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?

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?

If the data always starts with digits, this should be enough:

`^[^\s]+`

If not, something like this:

`\d[^\s]+`