Forum Discussion
Carriage Returns when Combining multiple CSV documents
Hello, I'm working on importing multiple CSV documents from a sharepoint folder using the combine files (binaries) function. When I do this there is a carriage return in an address field that wi...
If you're using the combine files UI, then it likely creates some helper queries like Sample File, Transform File, and Transform Sample File. I think you should be able to add "QuoteStyle=QuoteStyle.Csv" to Transform Sample File the same way you can add it to a single CSV. That should update the Transform File function which is used in your main query that does the combining.