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:
- SAP Managed Tags:
Accepted Solutions (0)
Answers (0)
| User | Count |
|---|---|
| 85 | |
| 10 | |
| 10 | |
| 9 | |
| 6 | |
| 6 | |
| 6 | |
| 5 | |
| 4 | |
| 3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.