Can anyone help? Thanks in advance.
I have the xml document like:
12345A
22345B
32345A
42345B
52345B
62345A
72345A
And like to transform it to another xml document. For all under , Start adding the folowing with when the last character of context of the is A; otherwise add the with the context when the last character of the context of the is “B”.
12345A
22345B
32345A
42345B
52345B
62345A
72345B
Hi,
I found this question to be quite a challenge because it requires procedural processing of your data, which does not sit comfortably with xsl’s declarative nature. I have attached an example which worked for me - I hope it gives you some ideas. Basically it steps through all the A items. For each A item it creates a new group and copies the A item. Then it locates the next A item, and explicitly copies all the B items which lie between the two A items. Before starting I had to remove whitespace from the xml because it interfered with the principle of node counting.
I would hope that there is a better way to do this, but I couldn’t find one.
HTH
test.xsl (1.56 KB)