Brian
02/18/2020, 5:47 PMREGEXP_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?michoel
02/18/2020, 10:23 PMREGEXP_REPLACE(REGEXP_SUBSTR({name},'^[^:]+ :'), ' :', '')
Brian
02/19/2020, 7:07 PM