cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Register to attend Discovery Summit 2025 Online: Early Users Edition, Sept. 24-25.
  • New JMP features coming to desktops everywhere this September. Sign up to learn more at jmp.com/launch.
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

Recommended Articles