Parsing full name using =Left

Jeff2269 · 06/12/24

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

Andrée Starå · 06/12/24

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

Ok.

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

Jeff2269 · 06/12/24

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

Andrée Starå · 06/12/24

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 · 06/12/24

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å · 06/12/24

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

Ok.

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

Jeff2269 · 06/12/24

Yes, Name "exited geo-Fence" Location

Andrée Starå · 06/12/24

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!

Parsing full name using =Left

Best Answer

Answers

Help Article Resources

Categories