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"," ")
Best answer by MarkShnierYou
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>
+24I 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>
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
