How to parse out part of a repeated phrase within a cell

I have created a new column called "Workstreams" that has a "CONTAINS" formula @row that parses workstream names out of a "tags" column. (The cell in that row and in that tag column has multiple tags that the CONTAIN formula is parsing into my Workstreams column.)

It works great until one of my workstream tag names is also PART of a name for other tags in that same cell. So, I need the workstream "Exxon" but not only does that column have "Exxon," it has "Exxon," "Exxon Weekly Report," "Exxon Team," and "Exxon Party."

I need a way to parse out "Exxon" so when I run a Workstream report the other "Exxon Weekly Report" etc. don't show up. I need it to return a filter on Exxon and leave out the other Exxon-tags. I tried hyphenating, but it still doesn't work. Help! :-)

Find more posts tagged with

Accepted answers

All comments

BullandKhmer

Just use column@row="Exxon" Instead of CONTAINS("Exxon",column@row)

KPH

Try HAS instead of CONTAINS. HAS is specifically for the situation you describe - finding one of many options in a multi-select cell but not relying on the string being unique.

Bassam Khalil

Hi @kfb,

Could you please add a screenshot of your sheet after removing any sensitive data? This will help us create the exact formula for you.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.