Left and Find Formula Issue

Andy S.

Are there any glaring issues with the following formula?

=LEFT([AR - Run 1 Size]@row, FIND("""", [AR - Run 1 Size]@row) - 1)

I'm trying to return the leftmost text that occur before the quotation mark. For example,

Original string: 2" InchFisher399

I want just the number 2

I just get #UNPARSABLE

Find more posts tagged with

Accepted answers

Andy S.

I figured it out. It didn't like looking for the quotation mark, so I changed it to look for the space after the quotation mark and then subtract by 2.

=LEFT([AR - Run 1 Size]@row, FIND(" ", [AR - Run 1 Size]@row) - 2)

All comments

Andy S.

I figured it out. It didn't like looking for the quotation mark, so I changed it to look for the space after the quotation mark and then subtract by 2.

=LEFT([AR - Run 1 Size]@row, FIND(" ", [AR - Run 1 Size]@row) - 2)

Genevieve P.

Thanks for posting your solution! 🙂

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.