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…
Silly Admin Trick: Removing Carriage Returns from Long Text Fields
Posted on