Returning text using IF Function

Hello!

I am trying to return text from another column that has a lot of text in. I'm using the IF, FIND, and RIGHT functions.. but it's not working. The intent is to search the DAQ Comments column for the word "PCI".. if it's there I want to return only one part of the text starting with the word "Other". If there is no match I want it to be left blank

The current formula looks like:

=IF(CONTAINS("PCI", [DAQ Comments]@row), (FIND("Other", [DAQ Comments]@row), RIGHT([DAQ Comments]@row, 2000)), "")'

Thank you!!

Find more posts tagged with

Accepted answers

Mark Cronk

Hi Christa,

Try:

=IF(CONTAINS("PCI", [DAQ Comments]@row), RIGHT([DAQ Comments]@row, LEN([DAQ Comments]@row)-FIND("Other", [DAQ Comments]@row)+1), "")

Mark

All comments

Mark Cronk

Hi Christa,

Try:

=IF(CONTAINS("PCI", [DAQ Comments]@row), RIGHT([DAQ Comments]@row, LEN([DAQ Comments]@row)-FIND("Other", [DAQ Comments]@row)+1), "")

Mark

Christa Brown

Thank you again! I got it using the MID Function and the FIND function to give MID a starting point. PHEW!!

Mark Cronk

Glad you solved it. Thank you for using the Community.

Mark

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.