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… Continue reading Saved Search Formula to Extract Characters of a String