Join Slack
Powered by
Hi, how do i write a formula which checks if 1st 4...
# suiteanalytics
g
ganoo7
10/14/2019, 3:47 PM
Hi, how do i write a formula which checks if 1st 4char in a string are numbers?
j
jmacdonald
10/14/2019, 3:51 PM
you could use regex to do this, this would be the regex
^[0-9]{4}
jmacdonald
10/14/2019, 3:52 PM
Not sure how to use that in a formula though, maybe REGEXP_LIKE({fieldid}, '^[0-9]{4}') ? or something along those lines
6
Views
Open in Slack
Previous
Next