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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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...
  2. kshick

    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...
  3. kshick

    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">...
  4. kshick

    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()"/>...
  5. kshick

    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...
  6. kshick

    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
  7. kshick

    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...
  8. kshick

    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
  9. kshick

    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
  10. kshick

    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"?>...

Part and Inventory Search

Back
Top