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

AI generated answer (using internal Slack threads):

Based on the conversations provided, it seems that the question is about changing the delimiter in a saved search from ":" to "-". However, none of the conversations provided directly address this question. In NetSuite, the format of the saved search results is generally determined by the system and cannot be changed directly within the saved search itself. The delimiter used in hierarchical fields like "Business Units" is system-defined and cannot be changed within the saved search. However, you might be able to achieve this by creating a formula field in your saved search that replaces the ":" with "-". Here is an example of how you might do this: 1. In your saved search, go to the Results tab. 2. Click on "New Field". 3. In the "Summary Type" dropdown, select "Formula (Text)". 4. In the "Formula" field, enter a formula like this:

REPLACE({your_field}, ':', '-')

5. In the "Label" field, enter a name for your new field. 6. Click "OK" to save your new field. This will create a new field in your saved search results that contains the same data as your original field, but with the ":" replaced by "-". Please replace

{your_field}

with the actual field id you want to change. Please note that this is a workaround and may not work in all cases. Also, the REPLACE function may not be available in all versions of NetSuite or for all field types. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******