What is wrong with this formula:

SUBSTR({name},INSTR({name},":")+2)

AI generated answer (using internal Slack threads):

The formula

SUBSTR({name},INSTR({name},":")+2)

is trying to extract a substring from the

{name}

field, starting from the position where the colon

:

is found plus 2. The issue with this formula is that the

SUBSTR

function in NetSuite's SQL requires three parameters: the string from which to extract, the start position, and the length of the substring. In your formula, you're only providing two parameters, the string and the start position. The correct formula should look something like this:

SUBSTR({name},INSTR({name},":")+2, LENGTH({name})-INSTR({name},":")-1)

. This formula will extract a substring from the

{name}

field, starting from the position where the colon

:

is found plus 2, and ending at the end of the string. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******