case when formula to get the account and reblace : with - in a saved search

AI generated answer (using internal Slack threads):

Based on the conversations, to get the account and replace ":" with "-" in a saved search, you can use a SQL formula. Here is an example of how you can do it:

CASE WHEN {name} LIKE '% : %' THEN REPLACE(REGEXP_SUBSTR({name},'\\D[^:]+'), ':', '-') ELSE NULL END

This formula checks if the account name contains ":", if it does, it extracts the account name up to the ":" using the REGEXP_SUBSTR function and then replaces ":" with "-" using the REPLACE function. If the account name does not contain ":", it returns NULL. Please note that you might need to adjust this formula depending on your account naming convention and requirements. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******