Link to home
Start Free TrialLog in
Avatar of philsivyer
philsivyer

asked on

replacing breaks

Hello
I am using a reporting tool to download some html fields from an oracle database.  I am stripping out breaks using the following in a formula field in my report ...
REPLACE({COMMENT_HTML2},"<br />","<br>");
Unfortunately, any single line breaks are removed.
What I would really like is to strip out any double/multiple breaks but leave a break if there is just the one.
Regards
ASKER CERTIFIED SOLUTION
Avatar of Designbyonyx
Designbyonyx
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of philsivyer
philsivyer

ASKER

THANKS