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)

    joey

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

       

       

      file1    string1

               string2

      file2    string1

      file3    string1

               string2

       

      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]