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
Tagged:
0