can we change the : to be - in a saved search exam...
# ask-stanley-ai
n
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 field in the saved search
c
AI generated answer (using internal Slack threads):
Yes, you can change the ":" to "-" in a saved search. However, this would require you to use a formula field in your saved search. Here's an example of how you can do it: 1. In your saved search, add a new column. 2. For the type, select "Formula (Text)". 3. In the formula field, you can use the REPLACE function to replace ":" with "-". For example, if your account field is {account}, your formula would look like this:
REPLACE({account}, ":", "-")
. This will replace all instances of ":" with "-" in the account field for your saved search. Please note that this will only affect the display of the data in this saved search, and will not change the actual data in the account field. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******
Slack thread 1: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.822973549
Slack thread 2: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.820059538
Slack thread 3: here (available only if the original thread was posted in the last 90 days)
Similarity score: 0.819904208
Please provide your feedback on this answer.