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!

Find more posts tagged with

Formulas

Accepted answers

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)

All comments

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)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.