cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar
miguello
Level VI

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?

 

 

0 REPLIES 0