I was faced with the possibility of writing this from scratch and while I love a challenge, sometimes it’s easier to just post it:)<\/p>\n\n\n
\n<?xml version="1.0" encoding="UTF-8"?>\n <xsl:stylesheet xmlns:xsl="http:\/\/www.w3.org\/1999\/XSL\/Transform"\n version="2.0">\n\n <xsl:output method="text"\/>\n\n <xsl:variable name="fields" \n select="distinct-values(\/\/file\/*[not(*)]\/name(.))"\/>\n\n <xsl:template match="\/">\n <!--header row-->\n <xsl:value-of select="$fields" separator=","\/>\n\n <!--body-->\n <xsl:apply-templates select="*"\/>\n\n <!--final line terminator-->\n <xsl:text>
<\/xsl:text>\n <\/xsl:template>\n\n <!--elements only process elements, not text-->\n <xsl:template match="*">\n <xsl:apply-templates select="*"\/>\n <\/xsl:template>\n\n <!--these elements are CSV fields-->\n <xsl:template match="file\/*[not(*)]">\n <!--replicate ancestors if necessary-->\n <xsl:if test="position()=1 and ..\/preceding-sibling::file">\n <xsl:for-each select="ancestor::file[position()>1]\/*[not(*)]">\n <xsl:call-template name="doThisField"\/>\n <\/xsl:for-each>\n <\/xsl:if>\n <xsl:call-template name="doThisField"\/>\n <\/xsl:template>\n\n <!--put out a field ending the previous field and escaping content-->\n <xsl:template name="doThisField">\n <xsl:choose>\n <xsl:when test="name(.)=$fields[1]">\n <!--previous line terminator-->\n <xsl:text>
<\/xsl:text>\n <\/xsl:when>\n <xsl:otherwise>\n <!--previous field terminator-->\n <xsl:text>,<\/xsl:text>\n <\/xsl:otherwise>\n <\/xsl:choose>\n <!--field value escaped per RFC4180-->\n <xsl:choose>\n <xsl:when test="contains(.,'"') or \n contains(.,',') or\n contains(.,'
')">\n <xsl:text>"<\/xsl:text>\n <xsl:value-of select="replace(.,'"','""')"\/>\n <xsl:text>"<\/xsl:text>\n <\/xsl:when>\n <xsl:otherwise><xsl:value-of select="."\/><\/xsl:otherwise>\n <\/xsl:choose>\n <\/xsl:template>\n\n <\/xsl:stylesheet>\n<\/pre><\/div>\n\n\nAnd as a special added bonus. Here is the XSL to eliminate any extraneous information from the pipeline.<\/p>\n\n\n
\n<?xml version="1.0" encoding="UTF-8"?>\n<xsl:stylesheet xmlns:xsl="http:\/\/www.w3.org\/1999\/XSL\/Transform" version="2.0">\n\t<xsl:output method="xml" encoding="UTF-8" indent="yes" omit-xml-declaration="yes"\/>\n\t<!-- ======================================= -->\n\t<!-- Identity template -->\n\t<!-- ======================================= -->\n\t<xsl:template match="@*|node()">\n\t\t<xsl:copy>\n\t\t\t<xsl:apply-templates select="@*|node()"\/>\n\t\t<\/xsl:copy>\n\t<\/xsl:template>\n\t<!-- ======================================= -->\n\t<!-- Exclude the file path attribute. -->\n\t<!-- ======================================= -->\n\t<xsl:template match="file">\n\t\t<xsl:copy>\n\t\t\t<xsl:apply-templates\/>\n\t\t<\/xsl:copy>\n\t<\/xsl:template>\n\t<!-- ======================================= -->\n\t<!-- Exclude the content element. -->\n\t<!-- ======================================= -->\n\t<xsl:template match="file\/content"\/>\n<\/xsl:stylesheet>\n\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"I was faced with the possibility of writing this from scratch and while I love a challenge, sometimes it’s easier to just post it:) And as a special added bonus. Here is the XSL to eliminate any extraneous information from the pipeline.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[22],"tags":[],"class_list":["post-1178","post","type-post","status-publish","format-standard","hentry","category-xsl","author-aron"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4bBkH-j0","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/1178","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1178"}],"version-history":[{"count":3,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/1178\/revisions"}],"predecessor-version":[{"id":1181,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=\/wp\/v2\/posts\/1178\/revisions\/1181"}],"wp:attachment":[{"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1178"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1178"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/asberry.org\/blog_tech\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1178"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}