Mapping of German special chars in script not working

[#1]

Hi,

I try to map region names from capital letters to only starting capital letter, e.g. 'NORD' to 'Nord'.

This is working fine in a QVW file, but doesn't work for 'SÜD' and 'SÜD-WEST' when using an external script for the code. There I still have both values in the data, SÜD and Süd. Anyone an idea, what might be the issue?

MAPPING

LOAD * INLINE [

    NL_DESC, NL_DESC_NEU

     NORD, Nord

     NORD-OST, Nord-Ost

     NORD-WEST, Nord-West

     OST, Ost

     RHEIN-MAIN, Rhein-Main

     SÜD, Süd

     SÜD-WEST, Süd-West

     WEST, West

     Zentrale, Zentrale

];

SF_TARGET:

LOAD Monat,

     ...

      ApplyMap('Correct', NL_DESC) as NL_DESC,

;

SQL SELECT

     ...

     NL_DESC,

FROM

<table>;

Thanks

[tresesco · Accepted solution]

Try using Capitalize(), like:

Load

     capitalize(NL_DESC) as NL_DESC

[#3]

This is working fine, thanks.