Validation rule for coding mask

[former_member282774]

HI,

We have two coding masks:

00XX-XX.XX.XX.00.00

00XX-XX.0.00.00.00.00

PROJID is SIMILAR for two masks: 00XX(I could maintain IF00 as one mask but user wants to have unique PROJID)

Example: ID00

Example: IF00

I have to maintain a validation rule separately for IF00 projects which is unique for one Project Profile.

Coding Mask "00XX" to be used for Project Profile "Z00002"

Prequiste:

PROJ-PROFL='Z00002'

Check:

PROJ-PSPID=1-4='00XX'

The above rule takes 00XX into account since our PROJID is similar for two masks.

Note: IF00 is our PROJECT ID for OPEX but PROJID mask is 00XX

How can we achieve this validation?

[Former Member · Accepted solution]

Dear Sirin,

Try out the following in validation,

Prerequisite:

PROJ-PROFL='Z00002'

Check:

PROJ-PSPID :1-4: = 'IF00'

as IF00 is your Project ID (it as per my understanding from above query) is part of Project Coding. it means you have project coding IF00 00XX-XX.XX.XX.00.00 (whatever the separator you have used in between) 1 to 4 character are not "00XX' they are actually your Project ID.

Try this out, please do let me know if am not understand it correctly.

Regards,

Omkar Deshpande

[Former Member]

Dear Sirin,

If Issue is resolved please Close the thread

Regards,

Omkar

[former_member282774]

HI Omkar,

Sorry about that.I am closing the thread now.