I have a client looking to include the parent acco...
# generalp
Paul Giese
09/02/2021, 9:52 PMI have a client looking to include the parent account string on a transaction saved search. I'm new to SQL formulas. Does anyone have an idea on how to do this?
Paul Giese
09/07/2021, 3:29 PMIn case someone needs to do this in the future, here is the formula I used:
Copy code
TRIM(REGEXP_SUBSTR({accountgrouped}, '[^:]+'))4 Views