Trying to get data using the RIGHT formula
I have the following data where I am trying to parse the (ISPHUBS6AAA) from the string below.
Assets 1 = ORRR39ORMOOOBEACH (ISPHUBS6AAA)
I use the RIGHT formula ...
=RIGHT([Assets 1]@row, FIND("(", [Assets 1]@row))
But I get the following string returned
Result = BEACH (ISPHUBS6AAA)
How do I get just the (ISPHUBS6AAA) returned?
Thank you!
Best Answer

I figured it out!
=RIGHT([Assets 1]@row, FIND(")", [Assets 1]@row)  FIND("(", [Assets 1]@row) + 2)
This can be closed.
Answers

I figured it out!
=RIGHT([Assets 1]@row, FIND(")", [Assets 1]@row)  FIND("(", [Assets 1]@row) + 2)
This can be closed.

That works... the more traditional way is to subtract the location of the character you are searching for from the total length and add a digit back.
=RIGHT([Assets 1]@row, LEN([Assets 1]@row)  FIND("(", [Assets 1]@row) +1)
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.8K Get Help
 65 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 56 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!