cancel
Showing results for 
Search instead for 
Did you mean: 

Syndication of text fields with special characters

vpawate
Explorer
0 Kudos

We have several text fields with thousands of records in the repository.  Most of these records have single quotes eg. 4'2" or backslash eg 1/2

syndicating these to the target hybris system - causes problems during import into Hybris.


We are exploring the below option :

Put the entire text field context in double quotes so that Hybris ignores the special characters.


How can we make this happen in MDM ?


Does anyone have any other ideas  to address the special characters ?


FYI - we don't have any other middle ware like SAP PI in the landscape.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Vinay,

There are various ways to handle special characters in SAP MDM.

1. The most effective solution is to not allow the user to enter special characters at the time of entering data using Portal or Data Manager. In both the cases this can be handled with the help of validation check.

Expression for such kind of validation will be

HAS_ALL_CHARS(XXXX,"0","9")

here, replace XXXX with your field. This expression will not allow user to enter any special character in this field.

Also, If you are importing data using Import Manager then definitely you can normalize this field data using Conversion filters.


2. Another way of doing it is by writing an Assignment after the import of data and replacing the special characters by space or NULL. Again you can write an expression accordingly.


In any of the above cases you might have to write more than one expression based on the number of Special characters you have in your field.


3. To use middle ware, but as stated by you , you do not have any middle ware to send the data.


Hope this helps.


BR,

Parul