I tried for many days but to no avail. to I have an XML column called of_xml
in a PostgreSQL table called s.dict
.
It looks like this:
<?xml version=""1.0"" encoding=""UTF-8"" standalone='no'?>
<?xml-stylesheet type=""text/xsl"" href=""http://192.168.60.21/pae-bpm-web/rtf/PlantillaResolucion.xsl""?>
<Documento xmlns="" http://www.c/2005/05/CGRDoc "" xmlns:ns0="" http://www./09/xmldsig# "">
<Contenido>
<Folio>
<Numero>R-01</Numero>
<Agno>2019</Agno>
</Folio>
<ext:Resolucion xmlns:ext="" http://www./CGRDoc "" id="" Resol "">
<ext:Resolucion Id="" FirmaResolucionDefault "">
<FolioExpediente>R-19</FolioExpediente>
<CtlPrevLeg>EXENTA</CtlPrevLeg>
<NivelConfid>PUBLICO</NivelConfid>
<Materia/>
<Lugar>S</Lugar>
<Fecha>2019</Fecha>
<A>MANUEL</A>
<TipoOficio>SACO</TipoOficio>
<Ord/>
<Ant>PresentaciĆ³n <br/></Ant>
<Mat>Proporciona<br/></Mat>
<Ftes>Ley<br/></Ftes>
<Conc><br/></Conc>
<Separador>
<Parrafo>1.- Ud. 2018.
</Parrafo>
<Parrafo/>
<Parrafo>2.- Requerida.
</Parrafo>
<Parrafo/>
<Parrafo>3.- Atendido.
</Parrafo>
<Parrafo/>
<Parrafo/>
<Parrafo>Saluda, </Parrafo>
<Parrafo><a name="page-total-master0" id="page-total-master0"></a><a name="page-total" id="page-total"></a></Parrafo>
</Separador>
I tried a lot of times using XPath but I cannot get any positive results. I am interested in using the column "paragraph" because it has important information and I need to analyze words from it. Please help with showing the data in a table for export to a CSV.