Validation

[Former Member]

Hi All,

we have Process that run from Portal->MDM->ECC.When user enter the data in Portal some time they cut paste kind of stuff .

When it went to ECC for posting these document ,Idoc getting Error out with following heaxdecimal Values ‘.&#8217.As result we need to validate certain fields for this error .

Checked out on the hexadecimal value &#8217,it's look like end of line Error .If I want validate on this in MDM how can go with this.

Could you please let me know how can I validate these values .

Your help is appreciated.

Thanks,

Madhu

[Former Member]

Madhu,

The hexadecimal value

 &#8217 

corresponds to the RIGHT SINGLE QUOTATION MARK.

In order to validate if an MDM field contains this hex value you can create a new validation in the Validations tab of the MDM 5.5 Data Manager.

Do this by right clicking in the left pane and choosing "Add Validation" from the context menu.

Assuming the MDM Field to check is Product Name you can enter the following Validation Expression:

IF(HAS_ALL_VALUES(Product Name,&#8217),FALSE)

Now you can run this newly created validation either manually or automatically (using Workflows) on your MDM Records. Those MDM Records containing the hex value

 &#8217 

in the Product Name field will fail in the above validation expression.

Hope this is useful information.

Edited by: Uday Rao on Feb 26, 2010 8:30 AM