Search formula to find the length of a string which contains both char & int together

//Info: NFCC-31

We came across a situation in which we needed to determine the length of an entity record’s external id. The External id field’s value is a combination of characters and integers. By default, in a saved search, selecting Formula(Numeric) as criteria and then adding Function as length, Field, etc. results in LENGTH(char)externalid. The (char) here is unnecessary and will not work in this case. Update the formula as

LENGTH{externalid}  + Condition in Formula(Numeric)

Leave a comment

Your email address will not be published. Required fields are marked *