Hi Team please i want formulla for saved search ...
# general
y
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
Try this with whatever field the name is in put in the {yourfield} part of the formula: SUBSTR({yourfield}, INSTR({yourfield}, '-') +1)
🙌 1
m
If there a space between O BELL - Woodly Need to put +2 at the end
🙌 1
s
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.
👀 1
1
y
Thank you so mush it worked
👍 1