cancel
Showing results for 
Search instead for 
Did you mean: 

How would I complete a Length check on the columns?

How would I complete a Length check on the columns?

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

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.

Image: https://us.v-cdn.net/6030933/uploads/editor/b4/psfp2v5ihr9v.png

I hope this helps.

Thank You,
Akshay
0 Kudos