Question

4
Replies
124
Views
kaustav.guha Member since 2009 3 posts
Cognizant Technology Solutions
Posted: 7 months ago
Last activity: 6 months 3 weeks ago

incorrect BIX extract output for property values with new lines

Hi Team,

we are facing an issue with our bix extract output. Whenever a property in the extract rule is having values which includes new line, it is producing an incorrect output. A new record is created after the new line char and the entire record is splitted into multiple records in the extract. Please let me know if someone has faced similar issues and what is the solution/workaround.

Actual property value :

"Sample Example Text
07/02/19
$3,462.17
Control #: XXXXXXXXXXX"

In the extract we should be having a single record. But we are seeing the extract as below.

BIX Extract :

DT|"T-57295448"|"I-42390341"|"C-57029720"|"20190708T233421.457 GMT"|"20190708T233421.516 GMT"|""|"T-57295448"|"Pending-Outcome"|"true"|"P"|"Y"|"N"|"EC"|""|""|""|"N/A"|""|"20190708"|"20190702T070000.000 GMT"|"Our Customer Service Dept"|"20190702T070000.000 GMT"|"Our Customer Service Dept"|""|""|"OC"|"20190708"|""|""|""|""|""|"3462.17"|"XXXXX"|""|"Success"|"XXXXX"|"N"|"N"|""|""|""|""|""|"D"|""|""|""|""|"Y"|""|"1"|"OCDDT01"|""|""|"false"|"A"|"N"|"N"|""|"67"|"EMPTY"|"EMPTY"|"EMPTY"|""|""|"170"|"FAILURE"|"~"|""|""|"EMPTY"|""|"9999999999"|""|""|"20190708"|"EMPTY"|"0900"|"T-57295448:9999999999:DDT:EC:0900:N:N:N:false:No:N:A:XXXXXXXXX:N::N:N:N/A"|"Sample Example Text
DT|
DT|
DT|
"|""|"20190708"|""|"20190702"|"3462.17"|"070820191634214250"|"XXXXXXXXXXXXX"|"20190702"|"9999999999"|"2019-07-08 16.34.21.426"|"0900"|""|""|""|""|"XXXXXXXXXXX"|"C"|"1"|"RJF"|"XXXXXXXXXXX"|"VBK40150"|""|"0"|"VBK40532"|"00"|"XXXXXXX"|""|"No"|""|""|""|"N"|""|""|""|""|"NA"|""|""|"VBK10334=VBK30343;VBK10334=VBK30343;VBK11478=VBK30001;VBK10336=VBK30335;VBK10822=Yes;VBK10823=20190702;VBK10825=3462.17;VBK10826=3462.17;VBK11259=VBK30440;VBK10928=VBK30000;VBK10946=VBK30020;VBK10946=VBK30412;"|"true"|"Yes"|""|""|"Other"|""|""|""|"N"|"Other"|""|""|""|""|""|""|"N"|""|""|""|""|""|""|""|""|""|""|"No"|"false"|"false"|"N"|"N"|""|""|"N"|"N"|""|"N"|""|""|"N"|""|"N"|"N"|"OC"|"N"|""|"N"|""|"DDT"|"N"|"N"|"N"|""|"N"|"N"|"N"|""|"N"|"N"|""|"N"|"N"|"N"|"N"|"N"|"Y"|""|""|"N"|"N"|"N"|"N"|""|"N"|"N"|"N"|"N"|"N"|"N"|""|""|"N"|"N"|""|""|"Phone/Computer"|"Other"|"Other"|"No"|""|""|""|""|"3462.17"|""|""|""|""|"N"|"N"|"N"|"Y"|""|"N"|""|""|""|"N"|"N"|"N"|"N"|"N"|"N"|"N"|"N"|"N"|"N"|"N"|"N"|""|"N"|"N"|"N"|"N"|"N"|""|""|""|""|""|""|"20190702"|""|"OCDDT01"

***Edited by Moderator Marissa to update platform capability tags****

Reporting System Administration
Share this page LinkedIn