tsuji, when one doesn't have the knowledge or skills to accomplish something it is better to find another way to do it which I am doing now. I am going to fix this on the Server side and not use XML. It is clear that I have to come up to speed on XML before using it.
I can't thank you enough...
tsuji, you have gone the extra mile with me. I am very grateful. I can't expect you to do any more. If I were knowledgeable with XML I might have given you some help but as you guessed I am a complete neophyte. I am doing this project because the architecture of my database design demands an XML...
tsuji, I got the following code to produce a a csv sheet but still has white space.
<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:fmp="http://www.filemaker.com/fmpxmlresult"
exclude-result-prefixes="xsl fmp">...
thank you tsuji, got your correction. Tried many ways to get it to work. Let me show you where my confusion is.
Your code which works but has white space:
<xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW[position()>1]">
<xsl:variable name="therecord" select="current()"/>...
tsuji, I opened the file in Notepad and this is what I got. It is comma separated (CSV) but no field quotes except for the last value. It is the double commas that are strange and probably the problem. Any clues? -Ken
FirstName,LastName,Company
,,
Wanda,Smith,Louisiana/Louisiana State...
tsuji,it works. Thanks. This is the right track but it creates a blank row every other row. You can see that there is only one header row so that problem is solved. -Ken
CampaignNumber FirstName LastName
4 Evelyn Kanabuch
4 Tony Cavallo
4 Van Guyen
4 Roger Weathers
4 Wanda Smith...
tsuji, thank you for the solution. However I tried several combinations with no success even though it looks intuitively correct. I am an XML neophyte. Would you mind inserting your code into my code so I know exactly where you thought it should go. -Ken
tsuji, thank you for the suggestion. Your solution looks intuitively good but I tried various combination's without success. I am an XML neophyte. Would you mind inserting your code into my code so I know exactly where you think it should be.
-Ken
I am exporting from a FileMaker database and using an xsl style sheet to convert to Excel. Because of my database design I have two header rows before the data rows. I want to skip the first row. Is there a way to do that in the xsl? Below is my code.
<?xml version="1.0" encoding="utf-8"?>...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.