What's the syntax for a saved search formula using CONCAT when you need to add a space between two fields?

AI generated answer (using internal Slack threads):

The syntax for a saved search formula using CONCAT when you need to add a space between two fields in NetSuite is as follows: You need to use the double pipe

||

operator to concatenate fields or text. If you want to add a space between two fields, you can do so by including a space within single quotes

' '

. Here is an example:

{field1} || ' ' || {field2}

In this example,

field1

and

field2

are the internal IDs of the fields you want to concatenate. The

||

operator is used to concatenate the fields, and

' '

(a space within single quotes) is used to add a space between the fields. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******