New line in BIX extract file

General
, , ,
1

Hello,

We have included a property ABC in BIX.

Property Details:
BIX1.jpg

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.jpg

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?

2

I have referred below posts before creating a new post.

3

@srinit

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.

4

@srinit hi can you please explain your solution as we are also facing this issue