Discussions

Expand all | Collapse all

Formula to turn a Combined Text Summary field into a vertical list

  • 1.  Formula to turn a Combined Text Summary field into a vertical list

    Posted 02-24-2019 17:22
    Sometimes you may not want the "bubble" appearance of the native Combined Text Summary field on a report.  Here is a fun formula to change the appearance of a Combined Text Summary field into a vertical list.  

    var text CombinedText = ToText([My Text Concatenation Field]);

    var text RemoveSpaceAfterSemiColon = SearchAndReplace($CombinedText, "; ",";");

    // substitute new line for semicolon
    SearchAndReplace($RemoveSpaceAfterSemiColon,";","\n")




  • 2.  RE: Formula to turn a Combined Text Summary field into a vertical list

    Posted 02-25-2019 12:54
    Nice. I haven't had a chance to try out the new formula functions yet, but they seem useful...