February 26, 200817 yr Hi there, I am trying to export a tab delimitated text file for importing into another system. The problem is that the other system doesn't like the line feed (LF) and Carriage Return (CR) combination that FM produces. It only wants to see the LF character. Does anyone have an idea how to do this. I believe there may be a solution using XML, but I'm not familiar with xml.
February 26, 200817 yr I believe this xsl will do it. You'll have to use Export, with the XML option, then specify it as the XSL file to use. FM_DataTab_LF.xsl.zip
February 26, 200817 yr Author Fenton, I was hoping you would respond as you really seem to know XML! Many thanks for that, but it appears to strip out both CR and LF. Unfortunately I need the LF without the CR. Thanks in anticipation.
February 26, 200817 yr Author Fenton, Here are some sample files. The Right.txt file contains a character after the 18.5 on the first line which I am taking as a LF character. The Wrong.txt is the file generated with your stylesheet. Am I assuming too much about this character? Right.txt Wrong.txt
Create an account or sign in to comment