Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try using Capitalize(), like:
Load
capitalize(NL_DESC) as NL_DESC
This is working fine, thanks.