dilshod
column values with line breaks
it would be great to have an option to replace each line break in a field value by a single space character
currently, line breaks are preserved in the resulting text file and this stops me from further processing with SQL Server Integration Services (ssis cannot manage line breaks in csv files) - I had to implement an additional process that replaces line breaks in field values
hope for your understanding :-) regards, Mario
@mariomuja, it' similar to this request: #204 (Remove colums during conversion). Your request may help me as well.
The developer pushed a new commit, in which he added a "--no-line-breaks" option, it replaces line breaks with spaces. Please give it a try. PS: there is a similar argument available, called "--escape".
The newly added argument "--no-line-breaks" works for me.
This issue can be closed.
do not like this solution - not very nice to be forced to modify source data
instead of replacing line feeds by spaces, please allow us to set the escape character for the csv.writer call - then i can escape line feeds with whatever i like and later restore them to avoid deviations from the datasource; also see my new issue .. "--escape" is not very helpful, too
I agree to mariomuja, I want to replace line breaks by the character \n. By the way then I could get rid of the quotes. Using the options "--escape" and "--quoting None" currently causes an exception.
