3 Replies Latest reply: Mar 24, 2016 12:02 PM by Olly Bond RSS

    Monarch Utility-Inserting carriage returns/line feeds into a report (was:Memo Fields)


      I have a report of search strings that were found. The filename is listed once. 



      file1    string1


      file2    string1

      file3    string1



      I've created the report with the search strings in a memo field, but my report looks like the following:

      file1   string1    string2

      file2   string1

      file3   string1    string2   string3



      I'd like to insert cariage returns between the search strings.  Note that the strings have spaces in them, so I can't replace spaces with cariage returns.



      I'd like to do this so that when I export to excel, I can turn the word wrap property of the cells on, and the display will look much less cluttered.



      Any ideas?


      [size="1"][ September 25, 2006, 03:11 PM: Message edited by: Mike Urbonas ][/size]