You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to escape double quote character in .csv file of BIP Report

Received Response
68
Views
3
Comments

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)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!