Skip to Content

TrimRight Not Working as Expected in Lumira 2.1

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers