Normalising Customer Names

[Former Member]

Hi,

I am trying to write a utility that "normalises" customer names.

One of the things it needs to be able to do is to strip out non-alphanumeric characters.

For example: "Bill's Biscuits" would become "Bills Biscuits"

I know I can do a simple <variable> CO '0123456789ABCDEF...(etc)" to make this work for simple English characters but this needs to work in other languages (e.g. French) that have accents above the letters.

So, what I want to do is to convert the accented characters into non-accented characters. Is there a standard SAP function module that can do this? Otherwise I'm going to have to get my schoolboy French books out to find all of the possible accented characters!

Thanks,

Tristan

[Former Member]

Hi,

I am trying to write a utility that "normalises" customer names.

One of the things it needs to be able to do is to strip out non-alphanumeric characters.

For example: "Bill's Biscuits" would become "Bills Biscuits"

I know I can do a simple <variable> CO '0123456789ABCDEF...(etc)" to make this work for simple English characters but this needs to work in other languages (e.g. French) that have accents above the letters.

So, what I want to do is to convert the accented characters into non-accented characters. Is there a standard SAP function module that can do this? Otherwise I'm going to have to get my schoolboy French books out to find all of the possible accented characters!

Thanks,

Tristan

[andreas_mann3]

hi Tristan,

use fm prepare_string

and finally abap command condense ... no-gaps.

A.

[Former Member]

Hi Andreas,

Many thanks - did the trick.

Tristan