XSL: Retrieve text value as currency and add it
I have the following input XML.
<root>
<Envelope>
<Body>
<Response>
<Itin>
<Services Item="005"">
<Service Code="SOS">
<Extensions>
<Type>PAYMENT</Type>
</Extensions>
<Text>RA UK1 YVRYYZ0702P01DEC/SEAT/ACCP
</Service>
</Services>
<Itin>
</Response>
</Body>
</Envelope>
</root>
I want to get the Text value when the Type="PAYMENT" and @Code="SOS" and store it into a variable.
Then in the variable grab 2 substring values (after USD) and add it.
In this case, 1500 and 075; With decimal place 2 places from the right, so 15.00 and 00.75
Then the total would be 15.75
I want to store all 3 currencies into 3 separate variables.
<root>
<Envelope>
<Body>
<Response>
<Itin>
<Services Item="005"">
<Service Code="SOS">
<Extensions>
<Type>PAYMENT</Type>
</Extensions>
<Text>RA UK1 YVRYYZ0702P01DEC/SEAT/ACCP
</Service>
</Services>
<Itin>
</Response>
</Body>
</Envelope>
</root>
I want to get the Text value when the Type="PAYMENT" and @Code="SOS" and store it into a variable.
Then in the variable grab 2 substring values (after USD) and add it.
In this case, 1500 and 075; With decimal place 2 places from the right, so 15.00 and 00.75
Then the total would be 15.75
I want to store all 3 currencies into 3 separate variables.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I think this should work
<xsl:value-of select="format-number(($am
<xsl:value-of select="format-number(($am
ASKER
that prefixes the total with 11 spaces + value of sum. instead of have the whole value be contained within 11 spaces.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks. all of it worked. i appreciate it.
welcome
CSS
Cascading Style Sheets (CSS) is a language used for describing the look and formatting of a document written in a markup language. Usually used to change web pages and user interfaces written in HTML, it can also be applied to any kind of XML document. CSS is designed primarily to distinguish the content of a document from its presentation.
43K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
also, how would i pad the values with empty spaces?
for instance am1 and am2 has to be enclosed within 11 spaces regardless of amount.
For example
<15.00 > 11 spaces or
<125.00 > 11 spaces