How to escape double quote character in .csv file of BIP Report
Summary:
We have enclosed few columns of the BIP report within double quotes and output is expected in a csv file. This will overcome the columns having comma getting split into multiple columns in csv. But the columns which have double quotes within its value are getting split into multiple columns in csv.
Note: We don't want replace these characters and expectation is to send the values as is to target system.
Ex:
1. abc,def - to be send as abc,def in column1(currently this will split into two columns in csv as abc in column1 and def in column2)
Tagged:
0