Expand my Community achievements bar.

Flatten XML nodes?

Avatar

Level 2

Deal All,

Is there a way to flatten xml nodes?

Say, I have extracted the xml from the PDF document like this:

<xfa:data xmlns:xfa="http://www.xfa.org/schema/xfa-data/1.0/">

     <form1>

          <Subform>

                <Profile>

                      <Name>Joe</BankName>

                      <EmpID>123</EmpID>

                      <Start_Date>July 13, 2010</Start_Date>

                      <End_Date>2010-07-13</End_Date>

                      <PreparedBy>Paul</PreparedBy>  

                </Profile>

          <Subform>

          <Subform1>

                <Mailing>

                      <Address>123 no where LN</Address>

                      <City>somewhere</City>

                </Mailing>

          </Subform1>

     </form1>

</xfa:data>

And I want to flatten it like this:

<xfa:data xmlns:xfa="http://www.xfa.org/schema/xfa-data/1.0/">

     <form1>

          <Name>Joe</BankName>

          <EmpID>123</EmpID>

          <Start_Date>July 13, 2010</Start_Date>

          <End_Date>2010-07-13</End_Date>

          <PreparedBy>Paul</PreparedBy>  

          <Address>123 no where LN</Address>

          <City>somewhere</City>

     </form1>

</xfa:data>

Is this possible?

Thanks,

Paul

1 Reply

Avatar

Level 10

You could leverage the XSLT service, but you would still need to create the proper XSLT file.

Jasmin