Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.
COURSE of the MONTH
10 days, 19 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
When using XSL to transform XML for InDesign, How do I get the bold to output
Posted on 2011-03-07
Thank you in advance for any help you can provide.
I have an XML document provided to me, here's a snippet:
<?xml version="1.0" standalone="no"?>
<web-export>
<?whitespace-handling use-characters?>
<run-date>02/10/2011
<pub-code>UNG VP
<ad-type>CLS 6 Col Tab
<cat-code>Liner</cat-code>
<class-code>100</class-cod
<subclass-code>143</subcla
<position-description>Noti
<ad-number>0000146752-01</
<start-date>02/10/2011</st
<end-date>02/10/2011</end-
<line-count>6</line-count>
<run-count>1</run-count>
<customer-type>Transient</
<account-number>151915</ac
<account-name>OREGON WCP STATEWIDE CLASS</account-name>
<addr-1>133 ENTERPRISE DRIVE </addr-1>
<addr-2> </addr-2>
<city>VERONA</city>
<state>WI</state>
<postal-code>53593</postal
<country>USA</country>
<phone-number>6081111111</
<fax-number></fax-number>
<url-addr></url-addr>
<email-addr></email-addr>
<pay-flag>N</pay-flag>
<ad-description>ATTENTIOND
<order-source></order-sour
<order-status>Ready</order
<payor-acct>151915</payor-
<agency-flag>N</agency-fla
<rate-note></rate-note>
<ad-content>
<b>ATTENTION DIABETICS </b>with Medicare. Get a FREE Talking Meter and diabetic supplies at NO COST plus FREE home delivery! Best of all, this meter eliminates painful finger pricking! Call 1-888-667-5202 (wcan)</ad-content>
</ad-type>
I need to pull the data out of it that I need (not all) and apply formatting. I also don't want any repeating heads. I have accomplished this much with XSL.
What I can't get is the bold tag, within the ad-content tag to show up in the output.
Here is the XSL:
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<!--Container Element -->
<xsl:element name="ad-type">
<!--Start loooping through XML data -->
<xsl:for-each select="web-export/run-dat
<!--Set up elements. Do not ouput subclass-code and position-description dups-->
<subclass-code>
<xsl:value-of select='concat(subclass-co
</subclass-code>
<!--Carriage Return -->
<xsl:text> </xsl:text>
<!--Add ad content -->
<ad-content><xsl:value-of select="ad-content"/>
</ad-content>
<!--Carriage Return -->
<xsl:text> </xsl:text>
</xsl:for-each>
</xsl:element>
</xsl:template>
</xsl:stylesheet>
I have an XML document provided to me, here's a snippet:
<?xml version="1.0" standalone="no"?>
<web-export>
<?whitespace-handling use-characters?>
<run-date>02/10/2011
<pub-code>UNG VP
<ad-type>CLS 6 Col Tab
<cat-code>Liner</cat-code>
<class-code>100</class-cod
<subclass-code>143</subcla
<position-description>Noti
<ad-number>0000146752-01</
<start-date>02/10/2011</st
<end-date>02/10/2011</end-
<line-count>6</line-count>
<run-count>1</run-count>
<customer-type>Transient</
<account-number>151915</ac
<account-name>OREGON WCP STATEWIDE CLASS</account-name>
<addr-1>133 ENTERPRISE DRIVE </addr-1>
<addr-2> </addr-2>
<city>VERONA</city>
<state>WI</state>
<postal-code>53593</postal
<country>USA</country>
<phone-number>6081111111</
<fax-number></fax-number>
<url-addr></url-addr>
<email-addr></email-addr>
<pay-flag>N</pay-flag>
<ad-description>ATTENTIOND
<order-source></order-sour
<order-status>Ready</order
<payor-acct>151915</payor-
<agency-flag>N</agency-fla
<rate-note></rate-note>
<ad-content>
<b>ATTENTION DIABETICS </b>with Medicare. Get a FREE Talking Meter and diabetic supplies at NO COST plus FREE home delivery! Best of all, this meter eliminates painful finger pricking! Call 1-888-667-5202 (wcan)</ad-content>
</ad-type>
I need to pull the data out of it that I need (not all) and apply formatting. I also don't want any repeating heads. I have accomplished this much with XSL.
What I can't get is the bold tag, within the ad-content tag to show up in the output.
Here is the XSL:
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<!--Container Element -->
<xsl:element name="ad-type">
<!--Start loooping through XML data -->
<xsl:for-each select="web-export/run-dat
<!--Set up elements. Do not ouput subclass-code and position-description dups-->
<subclass-code>
<xsl:value-of select='concat(subclass-co
</subclass-code>
<!--Carriage Return -->
<xsl:text> </xsl:text>
<!--Add ad content -->
<ad-content><xsl:value-of select="ad-content"/>
</ad-content>
<!--Carriage Return -->
<xsl:text> </xsl:text>
</xsl:for-each>
</xsl:element>
</xsl:template>
</xsl:stylesheet>
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
4-
3
7 Comments
Active today
short answer:
replace this
<ad-content><xsl:value-of select="ad-content"/>
</ad-content>
by this
<xsl:copy-of select="ad-content"/>
value of will only show the text nodes
copy-of will make a deep copy
replace this
<ad-content><xsl:value-of select="ad-content"/>
</ad-content>
by this
<xsl:copy-of select="ad-content"/>
value of will only show the text nodes
copy-of will make a deep copy
Active today
long answer,
it is always better to avoid for-each in favour of apply-templates if you can
it is always better to avoid for-each in favour of apply-templates if you can
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<!--Container Element -->
<xsl:element name="ad-type">
<!--Start loooping through XML data -->
<xsl:apply-templates select="web-export/run-date/pub-code/ad-type"/>
</xsl:element>
</xsl:template>
<xsl:template match="ad-type">
<!--Set up elements. Do not ouput subclass-code and position-description dups-->
<subclass-code>
<xsl:value-of select='concat(subclass-code[not(.=preceding::subclass-code)], " ", position-description[not(.=preceding::position-description)])'/>
</subclass-code>
<!--Carriage Return -->
<xsl:text> </xsl:text>
<!--Add ad content -->
<ad-content><xsl:apply-templates select="ad-content/node()"/>
</ad-content>
<!--Carriage Return -->
<xsl:text> </xsl:text>
</xsl:template>
<xsl:template match="node()">
<xsl:copy>
<xsl:copy-of select="@*"/>
<xsl:apply-templates select="node()"/>
</xsl:copy>
</xsl:template>
</xsl:stylesheet>
Wow. you've got to be kidding?!
Will that take care of italics and underlines too?
Actually, it's a bit flakey...it doesn't always end the bold.
Will that take care of italics and underlines too?
Actually, it's a bit flakey...it doesn't always end the bold.
Active today
it takes care of all the deeper nodes, italics and underline too
do you mean that your source is not well formed?
what is flakey?
do you mean that your source is not well formed?
what is flakey?
I meant that it wasn't always ending the bold where it was supposed to, it would bold the whole paragraph instead of just the word(s) between the tags.
Your revised code worked perfectly. I posted the flaky comment before I seen your code.
One more question, I have a carriage return after the subclass-code because without it, the Paragraph marker was applying the style from the next element. Any ideas?
I really appreciate the help, I was pulling my hair out on this one.
Your revised code worked perfectly. I posted the flaky comment before I seen your code.
One more question, I have a carriage return after the subclass-code because without it, the Paragraph marker was applying the style from the next element. Any ideas?
I really appreciate the help, I was pulling my hair out on this one.
Featured Post
Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
When designing and editing page layouts in inDesign, fonts can become messy without the help of paragraph styles. How many times have you re-read through a document you created and noticed a sentence in the middle of a paragraph happened to be a dif…
Have you ever wanted to create graphical elements directly in inDesign? This tutorial will teach you how to have an image bound within text using the pathfinder tool in inDesign CS6. This technique will help decrease the amount of time spent opening…
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
Suggested Courses
Course of the Month10 days, 19 hours left to enroll
770 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.