cancel
Showing results for 
Search instead for 
Did you mean: 

DS4.1 - Address Cleansing using Global Address Cleanse transform

Former Member
0 Kudos
203

Hi All:

DS4.1 being used to extract data from SAP ECC, stage it and the staged data is used as source for global address cleansing transform. The output from the GAC transform seems to be inconsistent. For some countries the output is in English, and for some countries the output has some special characters in it. E.g. "São Paulo", "RHÔNE-ALPES", etc. Is there a possibility to convert these characters to proper English characters (without any accents)?

Appreciate your input on this.

Thanks, Arun J

Accepted Solutions (1)

Accepted Solutions (1)

paula_augedahl
Product and Topic Expert
Product and Topic Expert
0 Kudos

Arun,

You can use a search/replace function to convert any diacritical characters to the standard Latin1 character.  The Data Services blueprints offer an example of such a function.  It is a custom function named CF_RemoveDiacritcalCharacters.  See:

1263925 - Are Data Quality blueprints available? - Data Services

http://service.sap.com/xsearch

Hope this is helpful.

Thanks,

Paula

Former Member
0 Kudos

Hi Paula,

Thanks for this. I believe this should work. 🙂

Arun J.

Answers (0)