How to just get one node attribute value from duplicate node

JohnKiller · December 8th, 2011, 05:42 PM

The input XML:

Code:

<request attr1="John" attr2="King">
  <telephoneNumber telephone="1234567890">
    <detail value="P" tag="Other" />
    <detail value="789" tag="TT" />
    <detail value="N" tag="Sw" />
    <detail value="B" tag="HT" />
  </telephoneNumber>
  <telephoneNumber telephone="9876543210">
    <detail value="o" tag="Other" />
    <detail value="789" tag="TT" />
    <detail value="G" tag="Sw" />
    <detail value="K" tag="HT" />
  </telephoneNumber>
</request>

I want the output :

Code:

<request>
  <parameter>
    <Attr1>John</Attr1>
    <Attr2>King</Attr2>
    <TT>789</TT>
    <Tel>1234567890</Tel>
    <Tel>9876543210</Tel>
  </parameter>
</request>

The detail/@TT always has the same value in the input, but for the output I only need one, means I do not want the value 789789 for the output TT node, I want 789 for the output TT node.

Any idea how to use XSL 1.0 to do that?

Thank you in advance.

samjudson · December 9th, 2011, 04:39 AM

No idea where you are starting from, but something like this:

telephoneNumber[1]/detail[@tag='TT]/@value

This assumes that both TT values are the same and you just want to first one.

To be honest I'm not even sure how you are are generating the original incorrect value as you haven't shown us your code, so this might be completely wrong for you.

JohnKiller · December 9th, 2011, 10:40 AM

The input is generated by Java. After that I want to do the format translation. And I just copied them from my XML file (the phone number is not right, but in my code I just did the test using these two numbers). And the output was right except the TT field, it is 789789, I only want one TT value-789, ont append them together. Hope I tell my problem clearly.

In the input, I did not copy <?xml version="1.0" encoding="UTF-8"?> in the first line.

Sorry for any misunderstanding. And thank you for your reply.

JohnKiller · December 9th, 2011, 10:49 AM

Your solution works, and yes, I only need the first TT.

Thanks.

Quote:

Originally Posted by samjudson

No idea where you are starting from, but something like this:

telephoneNumber[1]/detail[@tag='TT]/@value

This assumes that both TT values are the same and you just want to first one.

To be honest I'm not even sure how you are are generating the original incorrect value as you haven't shown us your code, so this might be completely wrong for you.