0 Replies Latest reply: May 15, 2014 10:16 AM by PYelton _ RSS

    Replacing Line Feeds in Memo fields

    PYelton _

      I am using Monarch 10.5 to read MS SQL data from a memo field that has embedded line feeds (chr 10).  I need to output this data into a delimited text file for upload into another database.  If I use:

       

      strip(MyMemo,chr(10))

       

      the line feeds are successfully removed.  What I would LIKE to do is replace the line feeds with an ASCII character so that I can put the line feeds back in after I have manipulated the data and want to upload the data.  Unfortunately, the REPLACE and SUBSTITUTE_XL commands don't seem to work on line feed.  If I replace the above command with:

       

      replace(MyMemo,chr(10),"^")

       

      it doesn't work.  Anyone have any tricks to deal with this?  Any help would be very much appreciated.

       

      Paul