I have the following input XML.
<Text>RA UK1 YVRYYZ0702P01DEC/SEAT/ACCPT/CAD1000/095CD/050AB CCVIX0001E 123</Text>
I want to get the Text value and obtain the values after the 4th instance of "/" and before the next empty space. and build the following XML node
Where Total is sum of both Tax/@Amount.
Also, it is possible that Text would only contain only one tax code such as:
<Text>RA UK1 YVRYYZ0702P01DEC/SEAT/ACCPT/USD1500/075AB CCVIXX1237E 123</Text>
In which case,