Validations

[Former Member]

Hi All,

Can any one explain to me how does the Functions

LEFT,RIGHT,MID

work in MDM expression.

For MID function do we also need to consider the blank spaces ?

Thanks

AJ

[Former Member · Accepted solution]

Hi Amruta,

LEFT, RIGHT and MID are used to extract substring from the given string.

E.g. Jitesh Talreja 100 is the given string then

LEFT(FULLNAME,6) will give the result as Jitesh i.e. From Left of the Field specified starting from 1 character till the length mentioned.

RIGHT(FULLNAME,3) will give the result as 100 i.e. From Right of the Field specified starting from the last character till the lenght mentioned.

MID(FULLNAME,2,10) will give the result as itesh Talr i.e. Start from second character extract 10 characters.

Yes we need to count spaces as well in all three functions

Regards,

Jitesh Talreja

[Former Member · Accepted solution]

Perfect

Thanks