Showing results for 
Search instead for 
Did you mean: 

How would I complete a Length check on the columns?

Image Sensor
Currently, our journal ids need to be 10 characters long, what would I do to complete this check? 
Labels (1)
0 Kudos
1 Reply
DC Motor
Hello jkingcrow21,

In order to the length test on your journal Ids, you can create a computed column (using our compute column function) and then make use of the IF and Len compute functions in tandem.

If(len(journal_ids)=10, true,false) would be the exact formula that you would use. Below is an example where I have performed the length test on Show Name.


I hope this helps.

Thank You,
0 Kudos