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.
-----
If you find this information useful, let us know by reacting or commenting on this post!