Validate column values (make sure all values in column follow a specific pattern)
Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column match specific Regex. Like so:!IsMissing(Regex(Column(myColumn)[1], "^\w+(\d{3})\w+$", "\1"))
I can iterate through each row to make sure that all of them match, but maybe there is a better way?