trim after space

[#1]

Hello everybody,
I have the following problem. I have an order number. This number is divided into two parts. Example: v000-1000 test.
Now I want the part of the text expect located after the space. In this case would be the 'Test'.
Here's what I've tried:
subfield ("OP_NUMBER ',' ', -1) as Adhesives

There I get everything in front of the empty mark, so v000-1000.

subfield ("OP_NUMBER ',' ', +1) as Adhesives
Here I get the same effect.

Where is my mistake?

Many Thanks!

[Anonymous]

OP_NUMBER must not be included in '

use subfield(OP_NUMBER,,' ', -1)  should work

[Gysbert_Wassenaar]

If OP_NUMBER is a field name then remove all the quotes around it: subfield(OP_NUMBER,' ', -1)

[#4]

Thank you!

The Resutat not produce the desired results. I have the following number field there are: V000-1000 test test test.
I would now like the right part de strings. In the example I had to Test Test Test get returned. The subfield function returns me back V000-1000.