Problem Note 53667: Dynamic treatments that use custom detail tags do not remove blank values when you export to a file or database table
Dynamic treatments that use custom detail tags in SAS® Customer Intelligence Studio do not remove trailing blanks when you export to a file or database table.
The following example output demonstrates the behavior:
"AGE" "TAG_ELEMENT1_PACKTAG" "TAG_ELEMENT2_PACKTAG" "TAG_ELEMENT_3_PACKTAG"
56 "CC ,CC" "CC ,DM" "CC ,EM"
62 "CC ,CC" "DM ,CC" "EM ,CC"
As you can see, there are blanks between the values. These blanks are added because the exported file fills in blanks until the field length that is defined in the dynamic list is reached.
The expected behavior is that the blanks are trimmed so that the output looks like the following example:
"AGE" "TAG_ELEMENT1_PACKTAG" "TAG_ELEMENT2_PACKTAG" "TAG_ELEMENT_3_PACKTAG"
56 "CC,CC" "CC,DM" "CC,EM"
62 "CC,CC" "DM,CC" "EM,CC"
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Customer Intelligence Core Mid-Tier | Microsoft® Windows® for x64 | 6.1_M1 | 6.4 | | 9.4 TS1M0 |
64-bit Enabled AIX | 6.1_M1 | 6.4 | | 9.4 TS1M0 |
64-bit Enabled Solaris | 6.1_M1 | 6.4 | | 9.4 TS1M0 |
HP-UX IPF | 6.1_M1 | 6.4 | | 9.4 TS1M0 |
Linux for x64 | 6.1_M1 | 6.4 | | 9.4 TS1M0 |
Solaris for x64 | 6.1_M1 | 6.4 | | 9.4 TS1M0 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2014-07-23 15:28:36 |
Date Created: | 2014-07-21 09:54:10 |