Hi, how do i write a formula which checks if 1st 4...
# suiteanalytics
g
Hi, how do i write a formula which checks if 1st 4char in a string are numbers?
j
you could use regex to do this, this would be the regex
^[0-9]{4}
Not sure how to use that in a formula though, maybe REGEXP_LIKE({fieldid}, '^[0-9]{4}') ? or something along those lines