Parsing full name using =Left

The following gives me Mike in the column =LEFT(Update@row, FIND(", "Update@row) - 1), but I want Mike Smith in the column, but I can’t see how to capture the full name using spaces from the following row:

Update Row: Mike Smith entered geo-fence Mt View Road

Find more posts tagged with

Accepted answers

Andrée Starå

https://community.smartsheet.com/discussion/comment/440488#Comment_440488

Ok.

Is it always the same format? Full name edited geo….

All comments

Jeff2269

Sorry, this gives me Mike=LEFT(Sitter@row, FIND((" "), Sitter@row) - 1)

Andrée Starå

https://community.smartsheet.com/discussion/123218/parsing-full-name-using-left

Hi,

I hope you're well and safe!

Can you share some screenshots? (Please delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Jeff2269

I have an automated process that pulls emails into Smartsheet, and the email Subject is in the Event column. I want to extract the full name into the Person column and the location into the Location column.

Andrée Starå

https://community.smartsheet.com/discussion/comment/440488#Comment_440488

Ok.

Is it always the same format? Full name edited geo….

Jeff2269

Yes, Name "exited geo-Fence" Location

Andrée Starå

https://community.smartsheet.com/discussion/comment/440532#Comment_440532

Try something like this.

=IFERROR(LEFT(Event@row, FIND("exited", Event@row, 1) - 2), "")

Did it work?

✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

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.