KB Article #161571
padding characters missing in map expressions
Problem
-- padding characters missing in map expression
-- e.g: if X is " " fixed field with space as padding char, "A" & X & "B" will result in "AB" instead of "A B"
Resolution
* padding characters are removed by the parser and added by the builder(parser in output).
* X's value is NULL. "A" & NULL & "B" = "AB"
* cleverly use DML String functions(padString, replaceIfNull, ..., to resolve