Can someone help me with a saved search formula? C...
# suiteanalytics
b
Can someone help me with a saved search formula? Currently, if I use:
Copy code
REGEXP_REPLACE(REGEXP_SUBSTR({name},': [^:]+*$'),': ','')
This will return my child name without the parent. How can I modify this to only show the parent, or the words BEFORE the colon?
m
REGEXP_REPLACE(REGEXP_SUBSTR({name},'^[^:]+ :'), ' :', '')
👍 1
b
This did the trick Thanks Michoel