I am extracting data from a db table into a CSV file to import to Excel.
I'm using OSQL to create a *.OUT file that's comma delimited, then run a vbscript file to append the current date to the title and change the extension to .csv.
This is working ok, my problem is that I need to somehow handle line breaks within the data.
Some of the fields are text fields with breaqks stored in them and in the csv format cause a new line where there should not be one created.
How can I correct this?