I have the following input XML.
<Text>RA UK1 YVRYYZ0702P01DEC/SEAT/ACCPT/USD1500/075XG CCVIXXXXXXXXXXXX1237E</Text>
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.