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?