Validation for the Tuple field

[former_member480924]

Hi Experts,

The Validation to be written for the Tuple field. The EAN Code is a part of the tuple. If the users maintain the EAN Code which starts with 11 series i.e. first 2 digits only it should throw an error i.e. invalid Bar code. For the other digits it should not throw an error.

Please advice.

Thanks & Regards,

U G

[Former Member · Accepted solution]

Hi UG,

You can write at the Tuple level which can be something like -

LEFT(EAN,2) = "11"

Thanks,

Ravi

[former_member480924 · Accepted solution]

Thanks Ravi.

If additonal has to be added i.e. 21 & 31 then it should be LEFT(EAN,2)="11"&"21"&"31 Right?

[former_member193350 · Accepted solution]

Hello UG,

If you want to keep first two digits only out of these values ("11","21","31")  then you have to write the below expression:-

LEFT(EAN,2)="11" OR "21" OR "31"

Hope it helps.

Regards

Prateek

[Former Member · Accepted solution]

Hi UG,

You can try -

LEFT(EAN,2) = "11" OR LEFT(EAN,2) = "21" OR LEFT(EAN,2) = "31"

Thanks,

Ravi