Skip to Content

TrimRight Not Working as Expected in Lumira 2.1

Feb 28 at 07:33 PM


avatar image

I would like to trim all the text in a string field called Page1 to the right of the " - " occurrence to result in a new string field called Page2 that is shorter.

I have tried various methods within formulas (including removing spaces first, if statements, contain statements) and cannot seem to resolve. I have not found anything on the subject via Google or SAP Q&A and would appreciate any guidance. This seems so simple, yet is confounding me.

Sample data:

Sample formula:

trimright-data.jpg (28.2 kB)
trimright.jpg (3.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers