Anyone have a simple formula(numeric) I can use in...
# general
r
Anyone have a simple formula(numeric) I can use in a saved search for stating {internalid} starts with 1 or 2 or 3?
s
Did you mean to ask that your need ONLY those results where internal ID starts with 1 or 2 or 3?
e
I think SUBSTR is what you need to get the first character of an internal id
r
Yes @Sunny R
I’ll try @Edgar Valdés!
m
CASE WHEN SUBSTR({internalid}, 1, 1) IN ('1', '2', '3') THEN 'good' END
r
Thanks a lot @Marc!