Hi All,
as reported in the object I need to extract only all the fields inside this XML file also other included in square brackets not teh other, is there a way ?
[nz@mi-e2bi-prod-3 XML]$ cat Agenti.xml
<ImpactRequest><SearchFor><ModelItem><Path>[CRM - Agenti (Analisi Relational)]</Path></ModelItem></SearchFor><SearchIn><CMSelect>/content/folder[@name='E2BI']/folder[@name='CRM']</CMSelect></SearchIn><Params><URL> CMPath="/content/folder[@name='E2BI']/folder[@name='CRM']/folder[@name='Package']/package[@name='E2BI - CRM']/report[@name='A260316 Data Base Agenti']" Name="A260316 Data Base Agenti" Path="Cartelle pubbliche > E2BI > CRM > Package > E2BI - CRM" Type="Report" linkName="A260316 Data Base Agenti"><Item DirectImpact="1" FndIn="expression" QueryName="Query1">[CRM - Agenti (Analisi Relational)].[Agenti].[Cognome Agente]</Item><Item DirectImpact="1" FndIn="expression" QueryName="Query1">[CRM - Agenti (Analisi Relational)].[Agenti].[Nome Agente]</Item><Item DirectImpact="1" FndIn="expression" QueryName="Query1">[CRM - Agenti (Analisi Relational)].[Agenti].[Login Agente]</Item><Item DirectImpact="1" FndIn="expression" QueryName="Query1">[CRM - Agenti (Analisi Relational)].[Agenti].[Tipo Agente]</Item><Item DirectImpact="1" FndIn="expression" QueryName="Query1">[CRM - Agenti (Analisi Relational)].[Agenti].[Codice Fiscale Agente]</Item></CMObject></Results></ImpactRequest>[nz@mi-e2bi-prod-3 XML]$
Thanks
Bye
Andrea
as reported in the object I need to extract only all the fields inside this XML file also other included in square brackets not teh other, is there a way ?
[nz@mi-e2bi-prod-3 XML]$ cat Agenti.xml
<ImpactRequest><SearchFor><ModelItem><Path>[CRM - Agenti (Analisi Relational)]</Path></ModelItem></SearchFor><SearchIn><CMSelect>/content/folder[@name='E2BI']/folder[@name='CRM']</CMSelect></SearchIn><Params><URL> CMPath="/content/folder[@name='E2BI']/folder[@name='CRM']/folder[@name='Package']/package[@name='E2BI - CRM']/report[@name='A260316 Data Base Agenti']" Name="A260316 Data Base Agenti" Path="Cartelle pubbliche > E2BI > CRM > Package > E2BI - CRM" Type="Report" linkName="A260316 Data Base Agenti"><Item DirectImpact="1" FndIn="expression" QueryName="Query1">[CRM - Agenti (Analisi Relational)].[Agenti].[Cognome Agente]</Item><Item DirectImpact="1" FndIn="expression" QueryName="Query1">[CRM - Agenti (Analisi Relational)].[Agenti].[Nome Agente]</Item><Item DirectImpact="1" FndIn="expression" QueryName="Query1">[CRM - Agenti (Analisi Relational)].[Agenti].[Login Agente]</Item><Item DirectImpact="1" FndIn="expression" QueryName="Query1">[CRM - Agenti (Analisi Relational)].[Agenti].[Tipo Agente]</Item><Item DirectImpact="1" FndIn="expression" QueryName="Query1">[CRM - Agenti (Analisi Relational)].[Agenti].[Codice Fiscale Agente]</Item></CMObject></Results></ImpactRequest>[nz@mi-e2bi-prod-3 XML]$
Thanks
Bye
Andrea