Validation req no.1.

[Former Member]

Hello ,

We have a req to check if a field (prdt no.) is not null and also its lingth is 12 .It is of specific format having 3 uniq nos then a "-" then 3 nos then "-" and then 4nos.total length 12.

How to implement ?

Kindly help!!

Brad

[Former Member · Accepted solution]

Hi,

U can see the options given in mdm data manager guide page 240.

To apply the condition u can write a validation in MDM data manager.

and make that automatic and also include that as error warning Try to use the properties:

IS Not null,find ,len and mid.

I will just try and will tell u the exp.

rgds

Ankit

[Former Member · Accepted solution]

Thanks!!

Can u plz gv me the expression for this.

It will be very helpfull!!

Brad

[Former Member · Accepted solution]

Hi .

Just try this

(i have not check this in data manager) :

IS_NOT_NULL(‪Product no.‬)AND (((LEN(‪Product no.‬)= 12)AND ((FIND(‪Product no.‬,"-")= 4)AND (MID(‪Product no.‬,8,1)= "-")))

U can check the properties from page no.240 of mdm data manager guide to understand the feature of each

Just try and check ,may be i have missed some brackets !!

Hope it may work!!

Rgds

Ankit

[Former Member]

Hello All,

Thanks for quick reply.

I will check the expressions then i will reward points.

Brad

[Former Member]

Hello ,

Kindly update if the expression worked or not also if yes then u shd have given 10 points.

Rgds

Ankit

[Former Member]

Hi,

I have checked expression is working.

Thanksand i have rewarded the points.

Brad

[Former Member]

Hi Braddy,

Check out the below expression

IS_NOT_NULL(prdt no) AND LENGTH(prdt no)=12 AND MID(prdt no,4,1)="-" AND MID(prdt no,8,1)="-"

Try this out and kindly update us

Regards,

Jitesh Talreja