I am trying to get something that should be simple.

Field_A (text) has a calculated stored value of 2 or 3 words whose middle or right words might be a plus or minus value

Example 1: "Downgraded -21"

Example 2: "Level -5 updated"

Example 3: "Increasing +3,2

If I use MiddleWords (Field_A; 2; 1) I get

Example 1: "21" I should get "-21"

Example 2: "5" I should get "-5"

Example 3: "3,2" I should get "+3,2"

What is wrong ?

Many Thanks,

Vince

Filter (Table::field; ",+-0123456789" ) //put numbers and anything else you only want to show in the filter.

Won't help you with typos, or if there is an extra comma or dash.