Scenario
User needs to create a Saved Search formula to extract the first 4 characters of a string..
For example, the string is “netsuite”. The needed result is only “nets”.
Solution
Use the SUBSTR function to extract the desired substring.
Formula: SUBSTR({fieldid}, 1, 4)
Explanation:
- {fieldid}: Represents the field containing the string from which you want to extract the first 4 characters.
- SUBSTR({fieldid}, 1, 4): This formula extracts a substring from {fieldid} starting from the first character (index 1) and extending for 4 characters.
You can modify the variables in the formula depending on your need. For example, you need the first 5 characters starting from the 3rd character, then just change the numbers in the formula to SUBSTR({fieldid}, 3, 5)