Forum Discussion

rrad's avatar
rrad
Qrew Member
10 months ago

Removing line breaks from new forms rich text log

Hello everyone,

I recently re-created one of my legacy forms to new forms. One subtle difference is that new forms forces line breaks between log entries while legacy forms does not. Unfortunately, this is impacting the form factor of my reports.

Is there any way I can remove these line breaks from the rich text log? I have found this script as a report formula, but it does not work as intended.

SearchAndReplace([RichTextField],"\n"," ")

Forms
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    10 months ago

    I suggest that you make a temporary formula text field with a formula of just

    [my Rich text field]

    to see what's @ctuslly in the data. 

    then use successive search and replace functions in a single doula field to strip them out.  You may find <br><br>. As a line break or

    <p>
    or

    </p>