AnsweredAssumed Answered

MiddleWords function

Question asked by vincer on Feb 11, 2018
Latest reply on Feb 12, 2018 by vincer

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

Outcomes