Join Slack
Powered by
Anyone have a simple formula(numeric) I can use in...
# general
r
Ryan Longenecker
03/29/2023, 9:56 PM
Anyone have a simple formula(numeric) I can use in a saved search for stating {internalid} starts with 1 or 2 or 3?
s
Sunny R
03/29/2023, 9:59 PM
Did you mean to ask that your need ONLY those results where internal ID starts with 1 or 2 or 3?
e
Edgar Valdés
03/29/2023, 10:03 PM
I think SUBSTR is what you need to get the first character of an internal id
r
Ryan Longenecker
03/29/2023, 10:04 PM
Yes
@Sunny R
Ryan Longenecker
03/29/2023, 10:04 PM
I’ll try
@Edgar Valdés
!
m
Marc
03/30/2023, 11:30 AM
CASE WHEN SUBSTR({internalid}, 1, 1) IN ('1', '2', '3') THEN 'good' END
r
Ryan Longenecker
04/04/2023, 6:17 PM
Thanks a lot
@Marc
!
Open in Slack
Previous
Next