Forum Discussion

kamran's avatar
kamran
Frequent Visitor
8 years ago

Conditionally Replace Line-Breaks with Space within the same multi-line text field

Hi folks   (Appologies for also posting it to wrong forum "Report Server" a while before)   I have a multi-line text column (equivalent to nVarchar (max) ) which is getting data from SharePoint u...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi kamran,

You should share some sample data and list expected result, so that we can help you in details. You can create some fake data if your data is private.

Best Regards,
Angelia

kamran's avatar
kamran
Frequent Visitor
8 years ago

Thanks v-huizhn for your attention, Here is the sample data:

 

In 2017, a XYZ appointed external moderator post-moderated a large
number of assessments of the undergraduate programmes. While the overall
outcome of the post-moderation was “met” requirements, the moderator
highlighted some areas of concern that needed to be addressed urgently. The
academic team has worked closely with the School’s Management, and the
ABC and DEF combined Academic Directorate to address all issues. 

Overall, student achievement rates are excellent.

In this data, line breaks after "large" in first line, or "overall" in 2nd line or similarly in the next lines, are not acceptable. However line-break after "issues." in the 2nd last line is fine because there is a full stop (.) after the word "issues".

 

My below mentioned formula works blindly as it creates line-breaks after each Full Stop or the other way, it removes all line-breaks.