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

    Eliminating "Line Feeds"  imbedded in a Memo field

    PYelton _

      I have data that I am extracting from an MS SQL database into Monarch (10.5).  That data then needs to be exported into an ASCII delimited file.  I have a field that apparently contains an embedded character that causes the ASCII output to "line feed" and start on the next line.  I have successfully used the TextLine function in the past to parse out lines into multiple fields, but it isn't working here. 

       

      Does anyone know how to determine what the embedded character is?  Is there a way to remove it in Monarch using Replace or some other function?

       

      Any help greatly appreciated.  Thanks!

       

      Paul