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.
Aug 29, 2020 10:07 AM
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)
Solved! Go to Solution.
Aug 29, 2020 02:49 PM
If anyone is interested I figured it out
IF(FIND(" “,{Name}&’’),TRIM(SUBSTITUTE(LEFT({Name}&’’,SEARCH(”",{Name}&’’)-1))),{Name})
Aug 29, 2020 11:25 AM
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})
Aug 29, 2020 02:49 PM
If anyone is interested I figured it out
IF(FIND(" “,{Name}&’’),TRIM(SUBSTITUTE(LEFT({Name}&’’,SEARCH(”",{Name}&’’)-1))),{Name})