Silly Admin Trick: Removing Carriage Returns from Long Text Fields

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

Leave a Reply

Your email address will not be published. Required fields are marked *