can we change the : to be - in a saved search example "6102 Discretionary : Meals - Business Related to be 6102 Discretionary - Meals - Business Related " this the account

AI generated answer (using internal Slack threads):

Based on the conversations provided, it seems that you can modify the display of account names in a saved search by using SQL formulas. However, the specific change you're asking for, which is to replace the colon (:) with a dash (-) in the account name, is not directly addressed in the conversations. In one of the conversations, a user shared a formula they used to extract a portion of the account name:

TRIM(REGEXP_SUBSTR({accountgrouped}, '[^:]+'))

. This formula uses regular expressions to match any characters up to the first colon in the account name. To achieve your goal, you might need to use a similar approach but with a different regular expression that replaces the colon with a dash. However, this would require a deeper understanding of SQL and regular expressions, and it's not guaranteed to work as expected. Please note that any changes you make to the display of account names in a saved search will only affect that specific saved search and not the actual account names in your NetSuite instance. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******