Below is the useCase
Input xml
<ns1:InvAdjRMS xmlns:ns1="www.thesourcethe.org">
<ns1:FHEAD_Root>
<ns1:FHEAD>FHEAD</ns1:FHEAD>
<ns1:Lineid>0000000001</ns1:Lineid>
</ns1:FHEAD_Root>
<ns1:INADJ_Root>
<ns1:INADJ>INADJ</ns1:INADJ>
<ns1:Lineid>0000000003</ns1:Lineid>
</ns1:INADJ_Root>
<ns1:INADJ_Root>
<ns1:INADJ>INADJ</ns1:INADJ>
<ns1:Lineid>0000000004</ns1:Lineid>
</ns1:INADJ_Root>
</ns1:InvAdjRMS>
Output String
FHEAD000000000120230803133049
INADJ0000000003
INADJ0000000004
how to achieve this using xQuery
I tried using concat
It is not clear where the
20230803133049comes from; the followingwould give you