New line in BIX extract file
Hello,
We have included a property ABC in BIX.
Property Details:
Issue Description: When we include/keep enter between content, we are seeing new lines in BIX report.
Ex: (Below values entered in Text Area)
BIX rule generates a csv file, in that file Note1 in line1 is coming as expected where as Note2 in line2 Note 3 in line2 and Note4 in line3 are coming in new lines. Business expecting those in the same line.
Do I need to make any configuration change to get them in a single line?
Accepted Solution
Updated: 15 Jun 2022 7:42 EDT
DXC Luxoft
SG
Update:
We have made below change in SQL query for BIX column where we run this query to generate BIX report.
Change: translate(ABC, CHR(10)||CHR(11)||CHR(13)||CHR(44)||CHR(64)||CHR(61), ' ') AS ABC
Now we are not seeing new lines in report.
DXC Luxoft
SG
I have referred below posts before creating a new post.
https://collaborate.pega.com/question/incorrect-bix-extract-output-property-values-new-lines
Accepted Solution
Updated: 15 Jun 2022 7:42 EDT
DXC Luxoft
SG
Update:
We have made below change in SQL query for BIX column where we run this query to generate BIX report.
Change: translate(ABC, CHR(10)||CHR(11)||CHR(13)||CHR(44)||CHR(64)||CHR(61), ' ') AS ABC
Now we are not seeing new lines in report.
