Recently had a project to use Jitterbit to query and pull data out of Salesforce.com in to a CSV file to import in to another system. All great and fine except long text fields with carriage returns were wrecking the CSV. This simple fix was all that was needed:
Replace(root$transaction.response$body$queryResponse$result$records.Account$BillingStreet$,’\n’,”);
Got it right off the support site linked below. Just changed up the field with the field I was using and re-ran, success!
https://getsatisfaction.com/dataloader/topics/exporting_data_how_do_i_remove_the_carriage_return_within_the_street_address_field