You’re offline. This is a read only version of the page.
I have a long string stored as a variable I want to trim. It's like:
asvsadfdfSDGADFGkafasflSDAFSAFFVDVVCdfsgsgffngnf-12345678
I'm trying to find a way to store just the last 8 characters or everything to the right of the dash "-".
The values in front of the dash vary in length.
For example in Excel I would use =RIGHT(A1,8) if the string was in cell A1.
=RIGHT(asvsadfdfSDGADFGkafasflSDAFSAFFVDVVCdfsgsgffngnf-12345678,8)
Any ideas?
Thanks!
Hey @r96359
You will need to Split the Text -
The above will return you a list, you then need to access the first item from the list - using the formula %TextList[1]%
This will return you the number -
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
Share
Report
All responses (
Answers (
