• #21544

    Admin needs to preserve carriage returns in transfer of text fields in Salesforce

    Hello developers,
    I am working on an apex script to do a one time transfer of data from one object to another. One of the fields that has to be transferred is a large text area field. It will be transferred to a Rich text area field. I can’t figure out how to preserve the carriage returns. Below is the simple version of my script that I have been using to try different things out. I know not to to put dmil inside of loops….again this is just a quick to find how to transfer the string. Without really understanding these different escape methods…I tried all of them…escapeEMCAScript, unescapeECMAScript, escapeHTML3 etc. But none of them work. Everything results in the string saved to the field without any returns.


    for(Project__c mp : [select Id, Brief__c, Opportunity__r.Description from Project__c

    where Id = ‘a10N0000001hF0WIAU’])


    mp.Brief__c = mp.Opportunity__r.Description.escapeHtml4();

    update mp;



    Salesforce | PRANAV PRANAV #706


    I haven’t tested this, but I think it might work – replace all newlines with an HTML break:

    for(Project__c mp : [select Id, Brief__c, Opportunity__r.Description from Project__cwhere Id = ‘a10N0000001hF0WIAU’])
    mp.Brief__c = mp.Opportunity__r.Description.replaceAll( ‘\\n’, ‘<br/>’ );
    update mp;

    Hope this helps you.

Viewing 2 posts - 1 through 2 (of 2 total)

Please to reply to this topic.


We're not around right now. But you can send us an email and we'll get back to you, asap.


About Us

Forcetalks is a Salesforce collaboration platform for coders & developers, geeks & nerds, consultants & business heads, admins & architects, managers & marketers and of course the business owners. A community where you can learn from, where you can contribute to. For you. For Salesforce. Read More...

Copyright 2019 Forcetalks. All Right Reserved.

Log in with your credentials


Forgot your details?