Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by kshick
-
XML to Excel - need to skip first row
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... -
XML to Excel - need to skip first row
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... -
XML to Excel - need to skip first row
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">... -
XML to Excel - need to skip first row
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()"/>... -
XML to Excel - need to skip first row
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... -
XML to Excel - need to skip first row
tsuji, it is of that form. I copied this from the csv file that was created. Every other line was empty. Any ideas? -ken -
XML to Excel - need to skip first row
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... -
XML to Excel - need to skip first row
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 -
How to create multiple table using XML
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 -
XML to Excel - need to skip first row
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"?>...
