Solved

ned help on XSLT sequence in the loop

Posted on 2009-07-06
18
264 Views
Last Modified: 2013-11-18
If i send the input is
1.  Lunch and 'BreakFast'  the out put should be =
BreakFast
 lunch
2.  'BreakFast' and Lunch  the out put should be
 BreakFast
lunch
3.  Lunch and Dinner the out put should be
Lunch
Dinner
4.  Dinner and Lunch  the out put should be
Lunch
Dinner

I alway have 2 field in the input. I dont get a combination Breakfast and Dinner.

Thank you

<xsl:for-each select="meal">
                   	<xsl:if test="TYPE = 'BreakFast'">
		  <BeginDate>
			<xsl:value-of select="concat('_ ',TYPE)"/>
		   </BeginDate>
		</xsl:if>
		<xsl:if test="DTM01 = 'Dinner'">
		    <EndDate>
			<xsl:value-of select="concat('_',TYPE)"/>
		    </EndDate>
		</xsl:if>
		<xsl:if test="DTM01 = 'Lunch'">
		     <EndDate>
			<xsl:value-of select="concat('_',TYPE)"/>
		      </EndDate>
		</xsl:if>
 
	<xsl:text>&#xA;</xsl:text>
</xsl:for-each>

Open in new window

0
Comment
Question by:developer777
  • 10
  • 8
18 Comments
 

Author Comment

by:developer777
ID: 24789401
updated points
0
 

Author Comment

by:developer777
ID: 24789402
updated points
0
 

Author Comment

by:developer777
ID: 24789404
help please
0
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24789477
you can put contains() in the tests, so you need two tests, preferably in when clauses
<xsl
        <xsl:choose>
            <xsl:when test="contains(translate(., 'LUNCH', 'lunch'), 'lunch') and contains(translate(., 'DINER', 'diner'),'dinner')">
                <xsl:text>Lunch and Dinner</xsl:text>
            </xsl:when>
            <xsl:when test="contains(translate(., 'LUNCH', 'lunch'), 'lunch') and contains(translate(., 'BREAKFST', 'breakfst'),'breakFast ')">
                <xsl:text>BreakFast and lunch</xsl:text>
            </xsl:when>
        </xsl:choose>

Open in new window

0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24789491
The translate() function I used for making the serach for you keywords, case-insensitive

Note: sending 4 follow ups in a minute will not make you get a quicker answer
0
 

Author Comment

by:developer777
ID: 24789646
I think I did not ask the question properly.
meal can occurs maximun of 2 times. This will run the loop 2 times., If i need to write in c, or java
isLunch = false;
isBreakFast = false;
isDinner = false;
string bf= null;
string lunch = null;
string dinner= null;
for() // runs 2
{
   If (meal.equals("BreakFast")
   {
      isBreakFast = true;
     bf = meal;
   }
If (meal.equals("lunch")
   {
      IsLunch = true;
      lunch = meal;
   }
If (meal.equals("Dinner")
   {
     isDinner = true;
     dinner = meal;
   }


}/ end loop.
If(isDinner)
{
   println(lunch); //new line
  print(dinner); //new line
   
}
If(isBf)
{
 print(isBreakFast ); //new line
 println(lunch); //new line
   
}
I am loking some thing similar to this in XSLT.

Note: I am in hurry, Today is a ruch day. sorry for the updates
Thank you


0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24789671
You are in a hurry, OK, please ask the right question from the start then
Please explain what you want, do I really have to go out and interprete java code to get what you need?
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24789695
Listen, this forum is about XSLT
- XSLT requires a completely different approach then procedural Javacode, so you procedural java code means nothing in this context
- input to XSLT is XML, I haven't( seen any XML so far

So please show the XML you start from or some examples of XML
based on that, show what you want as an output.
If you are really stressed and in a hurry, better learn to ask questions the right way
0
 

Author Comment

by:developer777
ID: 24789726
I am sorry.

I have one xml element, that can repeat 2 or more times. Possible values are Breakfast, lunch, or dinner.
if i loop through these by for each, the out put would be in the same order as input. But my requirement need a sequence.
input 1:

<ROOT>
   <Meal>lunch</Meal>
    <Meal>Breakfast</Meal>
</ROOT>
Out put should be always breakfast first if it is with lunch. ===>
breakfast
luncn
======
input 1:

<ROOT>
   <Meal>Dinner</Meal>
    <Meal>Lunch</Meal>
</ROOT>
Out put should be always Lunch first if it is with dinner. ===>

luncn
dinner

This would help

0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24789756
Thank you, this really helps.
You made a mistake by posting java code.
because you don't solve this in XSLT, using loops and variables
You can XPath directly in the XML structure


<xsl:template match="ROOT">
        <xsl:choose>
            <xsl:when test="contains(translate(Meal, 'LUNCH', 'lunch'), 'lunch') and contains(translate(Meal, 'DINER', 'diner'),'dinner')">
                <xsl:text>Lunch and Dinner</xsl:text>
            </xsl:when>
            <xsl:when test="contains(translate(Meal, 'LUNCH', 'lunch'), 'lunch') and contains(translate(Meal, 'BREAKFST', 'breakfst'),'breakFast ')">
                <xsl:text>BreakFast and lunch</xsl:text>
            </xsl:when>
        </xsl:choose>
</xsl:template>

Open in new window

0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24789761
If you need them on two lines, you could do something like this
<xsl:text>Lunch&#10;Dinner</xsl:text>
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24789765
and there is a bug, sorry
<xsl:when test="contains(translate(Meal, 'LUNCH', 'lunch'), 'lunch') and contains(translate(Meal, 'BREAKFST', 'breakfst'),'breakFast ')">
should be
<xsl:when test="contains(translate(Meal, 'LUNCH', 'lunch'), 'lunch') and contains(translate(Meal, 'BREAKFST', 'breakfst'),'breakfast ')">
0
 

Author Comment

by:developer777
ID: 24789934
I am geting this error
A sequence of more than one item is not allowed as the first argument of translate()
Thank you
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24790006
yep, sorry, that is a mistake, try this
    <xsl:template match="ROOT">
        <xsl:choose>
            <xsl:when test="Meal[contains(translate(., 'LUNCH', 'lunch'), 'lunch')]  and Meal[contains(translate(., 'DINER', 'diner'),'dinner')]">
                <xsl:text>Lunch and Dinner</xsl:text>
            </xsl:when>
            <xsl:when test="Meal[contains(translate(., 'LUNCH', 'lunch'), 'lunch')] and Meal[contains(translate(., 'BREAKFST', 'breakfst'),'breakfast')]">
                <xsl:text>BreakFast and lunch</xsl:text>
            </xsl:when>
        </xsl:choose>
    </xsl:template>

Open in new window

0
 
LVL 60

Accepted Solution

by:
Geert Bormans earned 500 total points
ID: 24790025
From your error message, I understand you are using XSLT2,
so you can use lower-case()
    <xsl:template match="ROOT">
        <xsl:choose>
            <xsl:when test="Meal[contains(lower-case(.), 'lunch')]  and Meal[contains(lower-case(.),'dinner')]">
                <xsl:text>Lunch and Dinner</xsl:text>
            </xsl:when>
            <xsl:when test="Meal[contains(lower-case(.), 'lunch')] and Meal[contains(lower-case(.),'breakfast')]">
                <xsl:text>BreakFast and lunch</xsl:text>
            </xsl:when>
        </xsl:choose>
    </xsl:template>

Open in new window

0
 

Author Comment

by:developer777
ID: 24790160
Than you. It works.  I am accepting solution. Can you explain me the what the does?
test="Meal[contains(lower-case(.), 'lunch')]  and Meal[contains(lower-case(.),'dinner')]">
Is it comparing every element in the NodeList

 Is there anyway we can do with out hard coding the values in the output.

Thank you
0
 

Author Closing Comment

by:developer777
ID: 31600369
Thank you for your time.
0
 
LVL 60

Expert Comment

by:Geert Bormans
ID: 24791607
welcome

Meal[contains(lower-case(.), 'lunch')]
is an XPath expression that selects the Meal child element that has a content that contains 'lunch' when lower-cased
In an test expression this will reult in false() if there isn't such a Meal child, or true() when there is

test="Meal[contains(lower-case(.), 'lunch')]  and Meal[contains(lower-case(.),'dinner')]">
checks whether there is a Meal child with 'lunch' AND one with 'dinner'. I made order not important that way

Which values would you like to not 'hardcode'?
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Excel file not created as expected 7 79
Animated .jpg? 13 97
PowerShell script to remove string in xml file 8 33
TSQL query to generate xml 4 46
Browsing the questions asked to the Experts of this forum, you will be amazed to see how many times people are headaching about monster regular expressions (regex) to select that specific part of some HTML or XML file they want to extract. The examp…
Browsers only know CSS so your awesome SASS code needs to be translated into normal CSS. Here I'll try to explain what you should aim for in order to take full advantage of SASS.
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question