Lawlerdev Posted February 26, 2008 Posted February 26, 2008 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.
Fenton Posted February 26, 2008 Posted February 26, 2008 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
Lawlerdev Posted February 26, 2008 Author Posted February 26, 2008 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.
Lawlerdev Posted February 26, 2008 Author Posted February 26, 2008 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
Recommended Posts
This topic is 6115 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now