Trying to get data using the RIGHT formula

cabbsman

I have the following data where I am trying to parse the (ISPHUBS-6AAA) from the string below.

Assets 1 = ORRR39-ORMOOO-BEACH (ISPHUBS-6AAA)

I use the RIGHT formula ...

=RIGHT([Assets 1]@row, FIND("(", [Assets 1]@row))

But I get the following string returned

Result = -BEACH (ISPHUBS-6AAA)

How do I get just the (ISPHUBS-6AAA) returned?

Thank you!

cabbsman

I figured it out!

=RIGHT([Assets 1]@row, FIND(")", [Assets 1]@row) - FIND("(", [Assets 1]@row) + 2)

This can be closed.

Carson Penticuff

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)

cabbsman

I figured it out!

=RIGHT([Assets 1]@row, FIND(")", [Assets 1]@row) - FIND("(", [Assets 1]@row) + 2)

This can be closed.

Carson Penticuff

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)