Hello,
I am using the formula below in a formula tool, but in instances where there are double digits after the last dash, it only removes one. (if I put 2 it will remove the "-" when a single digit). Have tried several different ways without success. Tried a RegEx, but I'm not the most versed with them and didn't get it quite right either.
TrimRight([Name],Right([Name], 1))
| Current | | Desired |
| | | |
| | | |
| Name | | Name |
| Fund-Number-9 | | Fund-Number- |
| Fund-Name-9 | | Fund-Name- |
| Fund-Type-9 | | Fund-Type- |
| Fund-Transaction-Amount-9 | | Fund-Transaction-Amount- |
| Fund-Units-Sold/Purchased-9 | | Fund-Units-Sold/Purchased- |
| Fund-Ending-Units-9 | | Fund-Ending-Units- |
| Fund-Unit Val-9 | | Fund-Unit Val- |
| Fund-Ending-Value-9 | | Fund-Ending-Value- |
| Fund-Number-10 | | Fund-Number- |
| Fund-Name-10 | | Fund-Name- |
| Fund-Type-10 | | Fund-Type- |
| Fund-Transaction-Amount-10 | | Fund-Transaction-Amount- |
| Fund-Units-Sold/Purchased-10 | | Fund-Units-Sold/Purchased- |
Thank you,
Kim
