AnsweredAssumed Answered Problems (Carriage Return in csv data)

Question asked by Lee Wade on Mar 25, 2012
Latest reply on Mar 25, 2012 by Lee Wade

I've been using the article below to create CSV's for importing into an MS SQL db.


Since I'm using Windows, I've created a cmd file to download and run the transforms and it's working great.


The problem I'm having is that the CSV files are sort of useless because they contain carriage returns in the data.

Is there a way I can modify the XSL to make the carriage returns within the fields Line Feeds or breaks?

I can't simply remove all the CR's because they are row delimiters and I'm not that clever.


Any other ideas would be appreciated.


Also there is HTML in the data that I want to get rid of, but that's not really a showstopper at this point.