Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

What am I missing? Remove everything after *

Topic Labels: Formulas
Solved
Jump to Solution
1172 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})