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 remove Carriage Return in the CSV files generated by the BIP

Hello,

This is in 25C.

We are generating a CSV file out of a BIP report that has output like this.

As we can see from the above, line #1,#2 and #3 are part of the question "Do you have one of the following?" We have this CSV file that will be consumed by a third-party application. How do we put these three options as part of the top line only without any wrapping or carriage return?

I tried replace (column, chr(13), '') in the BIP query but it is not working.

Help!

Thank you

Darsh

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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