Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

What am I missing? Remove everything after *

Topic Labels: Formulas
Solved
Jump to Solution
1367 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Eli_b
5 - Automation Enthusiast
5 - Automation Enthusiast

How would I remove everything after *? Using this works but also gets rid of the ones that only have 1 name.
LEFT(
{Name},
FIND(
" * ",
{Name}
)-1
)

Maslow *Loyal, Lovable Companion
Max
Bella
Hope’s Boy 2
Hope’s Boy 1
Chase *Snuggle Bug (pending)

1 Solution

Accepted Solutions
Eli_b
5 - Automation Enthusiast
5 - Automation Enthusiast

If anyone is interested I figured it out
IF(FIND(" “,{Name}&’’),TRIM(SUBSTITUTE(LEFT({Name}&’’,SEARCH(”",{Name}&’’)-1))),{Name})

See Solution in Thread

2 Replies 2
Eli_b
5 - Automation Enthusiast
5 - Automation Enthusiast

This keeps the single names but gives an error for the ones that I want to shorten
IF(FIND(" *",{Name}&’’),TRIM(SUBSTITUTE(LEFT({Name}&’’,SEARCH(" *",{Name}&’’))," *" *"")),{Name})

Eli_b
5 - Automation Enthusiast
5 - Automation Enthusiast

If anyone is interested I figured it out
IF(FIND(" “,{Name}&’’),TRIM(SUBSTITUTE(LEFT({Name}&’’,SEARCH(”",{Name}&’’)-1))),{Name})