This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

How do I use Replace formula in saved search.

&gt;*AI generated answer (using internal Slack threads):*
To use the REPLACE formula in a saved search in NetSuite, you can follow these steps:

1. In your saved search, go to the Results tab.
2. Click on the 'New Field' button.
3. In the 'Summary Type' dropdown, select 'Formula (Text)'.
4. In the 'Formula' field, enter the REPLACE formula. For example, if you want to replace the string "EST" in a field named 'yourfieldhere', you would enter `REPLACE({yourfieldhere},'EST','')`.

This will replace all instances of "EST" in the 'yourfieldhere' field with an empty string, effectively removing "EST" from the field in the results of the saved search.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1578511227130100|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.865345597

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1604066974135500|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.849809

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1629219162490700|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.844679



Please provide your feedback on this answer.