NSC | Extract Text/String separated by a symbol using a Formula

Scenario

User needs to separate the value of a field into 2 different columns

For example, the original value of the field is:

Hello, World

The required result is that "Hello" will be shown in one column and "World" in another column

Solution

To be able to separate the text before and after the comma, you can use these in a Formula (Text) field:

• Text before the comma: REGEXP_SUBSTR({fieldid}, '[^,]*')
• Text after the comma: REGEXP_SUBSTR({fieldid}, '[^,]*$')

Note: In this case, the separator is the comma symbol. If another symbol is used as the separator, just replace the comma in the [^,] part of the formula.