Hi Team
please i want formulla for saved search
to pick the values or characters after "-"
for exmple Christina O Bell - Woodly
i want only Woodly
please can you guys help is urgent
s
Stephanie Hughes
09/07/2023, 8:40 PM
Try this with whatever field the name is in put in the {yourfield} part of the formula: SUBSTR({yourfield}, INSTR({yourfield}, '-') +1)
🙌 1
m
Marc
09/07/2023, 8:43 PM
If there a space between O BELL - Woodly
Need to put +2 at the end
🙌 1
s
Stephanie Hughes
09/07/2023, 8:47 PM
Yeah I was presuming that some similar names wouldn't have a space (I don't often see that in hyphenated names), suppose you could always do a trim too for both situations.