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:
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:
it doesn't work. Anyone have any tricks to deal with this? Any help would be very much appreciated.