XML

20K

Solutions

9

Articles & Videos

13K

Contributors

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi Experts,

I use the following Invoke-Command to get values from remote xml files.

$tchome = 'c:\app\location'
$pointr = 'someuser2'
$output = Invoke-Command -ComputerName appserver -ArgumentList ($tchome,$pointr) -ScriptBlock {
      Param($tchome, $pointr)
      $xmldata = [xml](Get-Content $tchome\conf\context.xml)
      ($xmldata.SelectSingleNode("//Resource[@username='$pointr']")).url
}

Is there a way by which I can get these xml values from remote systems without using Invoke-Command because some of the servers have spn in them and give me the Kerberos authentication issue while executing scripts. (I dont have access to change the setspn as well to prevent this issue)

I would like to use some alternative (like Get-WmiObject) which does not cause the Kerberos error.

Details of error while using Invoke-Command:

[serv1] Connecting to remote server vpacdev failed with the following error message : WinRM cannot process the
request. The following error with errorcode 0x80090322 occurred while using Kerberos authentication: An unknown
security error occurred.
 Possible causes are:
  -The user name or password specified are invalid.
  -Kerberos is used when no authentication method and no user name are specified.
  -Kerberos accepts domain user names, but not local user names.
  -The Service Principal Name (SPN) for the remote computer name and port does not exist.
  -The client and remote computers are in different domains and there is no trust between the …
0
Free Tool: SSL Checker
LVL 9
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Hello!

I am writing a VB6 program to read an XML file.  The XML has encoding="UTF-8".

I have everything working with the exception of the embedded attachments.  There is a file name (jpg, doc, etc.) which I can pick up.  My problem is that the data element is just a bunch of characters.  Somehow I need to take the group of characters and convert it to a jpg or doc file.  

Does anybody know if this is possible,  and if so,  how is it done?

Thanks for your help!
0
I'm getting "duplicate attribute" error when attempting to create this document.  Is it not allowed to have the multiple Filter Field entries?
Jean

<?xml version="1.0" encoding="utf-8" standalone="no"?>
<ApiDocument xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://microsoft.com/wsdl/types/">
  <Request>
    <Settings></Settings>
    <Filters>
      <Filter Field="FiscalDate" Operator="Greater than or equal" Value="2017-06-19T00:00:00.000" />
      <Filter Field="FiscalDate" Operator="Less than" Value="2017-06-20T00:00:00.000" />
      <Filter Field="Location" Operator="Equal" Value="100" />
    </Filters>
    <SortDescriptions>
      <SortDescription Name="FiscalDate" Direction="Ascending" />
    </SortDescriptions>
  </Request>
</ApiDocument>
0
Dear experts,
I am facing a request from a customer, who maintains about 500 product sheets to different products. So far all the data were kept in Word and PDF files were made manually. Th maintenance was a nightmare and publishing online was nearly impossible.

Now the product sheets will be saved in a database / XML so that with help of some CSS libraries/frameworks (bootstrap etc.) site nice layout can be achieved while keeping the simplicity of editing content in a database and displaying the sheets online. For better reading and design reasons the sheets will contain TWO columns on normal screen and paper and 1 column only on mobile devices. This all is doable. Somehow.

However the next requirement is to be able to generate PDFs out of the same source (database/xml) and the PDF shall, of course, keep the layout for DIN A4 paper - header, footer, two columns, which flow always on first page from left column to right column and then on next pages again from left to right column. Like when you load a text in indesign for example. So that the PDFs when printed can be red.

Unfortunately the HTML page does not respect the fixed length of a DIN A4 paper and when showing two columns, they flow till the bottom of the page "infinitely".  When I tried to play with bootstrap for example, I was able to accomplish the HTML part, but then I was unable to either print it to PDF or even while using some PDF library to generate A4 standalone pages.

I hope I am expressing …
0
I have a problem serialializing xml

I do not get all 3 values of 'liggingen' back in the object. I only get the first value. I tried to make a list, but no success.
What is the error in the user defined object?

This is part of the user defined object
Public Class MatenEnLigging
        Public Liggingen As Liggingen
        Public Inhoud As Integer
        Public Oppervlakte As Integer
End Class

Public Class Liggingen
        Public Ligging As String
End Class

And this is part of the XML
<MatenEnLigging>
	<Liggingen>
        	<Ligging>aan bosrand</Ligging>
            	<Ligging>aan rustige weg</Ligging>
	        <Ligging>beschutte ligging</Ligging>
         </Liggingen>
	 <Inhoud>519</Inhoud>
	<Oppervlakte>150</Inhoud>
</MatenEnLigging>

Open in new window

0
( An extension of this question.. )

Given the below SQL Server 2008  T-SQL statement and XML fragment, how would I return the value 'Sammy Hagar' WHERE boo i:type="rockstar" ?
DECLARE @x XML 
SET @x = '<goo xmlns="http://underdog.com" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <foo>
   <boo i:type="fruit">banana</boo>
	<boo i:type="rockstar">Sammy Hagar</boo>
	<boo i:type="planet">Mars</boo>
	<boo i:type="movie">Heathers</boo>
	<boo i:type="practicaljoke">Rick Roll</boo>
  </foo>
</goo>'
;
WITH XMLNAMESPACES ('http://underdog.com' as d) 
SELECT @x.value('(/d:goo/d:foo/d:boo)[1]', 'varchar(64)') AS the_amount

Open in new window

0
< Highly mocked up SQL Server 2008R2 T-SQL >
DECLARE @x XML 
SET @x = '<goo xmlns="http://underdog.com" xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
  <foo>
    <boo>banana</boo>
  </foo>
</goo>'
SELECT @x.value('(/goo/foo/boo)[1]', 'varchar(64)') AS the_amount

Open in new window


I'm expecting to return a the_amount value of 'banana', but I'm always getting NULL.  What's the fix?
0
Is it possible to check duplicate attribute values within same element using an XSD ?

For example:

<MyProduct  category="school" code="123">Pencil</MyProduct>
<MyProduct category="home" code="343">Vase</MyProduct>
<MyProduct category="home" code="752">Fork</MyProduct>
<MyProduct category="school" code="123">Eraser</MyProduct>

Open in new window


In the above example, a pencil and an eraser belong to same category and have same code. How can I control that no product ("MyProduct") can have same category *and* code?
(if possible)


Note: in above example, categories and codes have a specific list of values (i.e. I know I have 12 categories and 728 codes).
Thank you
0
I have to build an XSD and I need to have the following double conditions declared when I define an element.

1. For a given element, only a specific list of attributes is permitted. Example:

<MyElement  currency="USD" payment="online" other="today">some values here</MyElement>

Open in new window

I need MyElement to be allowed to have attributes only 'currency' and/or 'payment' but no 'other' .


1.1. For the ALLOWED attributes, I need to have a permitted list of values. Example:

<MyElement  currency="USD" payment="online">some values here</MyElement>

Open in new window

I need the 'currency' attribute to take only values USD, AUD.. etc as I specify in a list (I have a list ready)
And I need the attribute 'payment' to take one of the two values "online" or "cash".

How can I declare the MyElement in an XSD ?
Your help is much appreciated..
0
I have my XML file which was generated using Soap-UI and our testers are able to execute the test case by calling the api's from Soap-UI with out any issues. But when the same I integrated as a part of continuous integration using Maven I am not getting the result as expected. All of the test cases are failing

Here is the pom.xml I have
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.smartbear.samples</groupId>
<artifactId>soapui-maven-plugin</artifactId>
<packaging>jar</packaging>
<version>1.0-SNAPSHOT</version>
<name>Maven 2 SoapUI Sample</name>
<url>http://maven.apache.org</url>
<pluginRepositories>
    <pluginRepository>
        <id>SmartBearPluginRepository</id>
        <url>http://www.soapui.org/repository/maven2/</url>
    </pluginRepository>
</pluginRepositories>
<build>
    <plugins>
        <plugin>
            <groupId>com.smartbear.soapui</groupId>
            <artifactId>soapui-maven-plugin</artifactId>
            <version>5.0.0</version>
            <configuration>
            <outputFolder>logs</outputFolder>
            <printReport>true</printReport>
            <junitReport>true</junitReport>
              <projectFile>/MyApp/soapui-project.xml</projectFile>
            </configuration> 
            <dependencies>
                <dependency>
   

Open in new window

0
Announcing the Most Valuable Experts of 2016
LVL 6
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Hi,
I am very new to shell scripting and i want to do following
read a xml file to extract value of <not_matched> tag,
from each of <SQL_Analysis>,<Data_Analysis>,<Graph_Analysis>,<Excel_Analysis>,<Pdf_Analysis> tags and compare it against a some value and depending on the result say Pass or Fail.

Any help much appreciated.

XML file as below :
<Execution_Stats>
      <Total_Executions>1</Total_Executions>      
      <Total_Errors>0</Total_Errors>
      <SQL_Analysis>
            <NOT_COMPARED>1</NOT_COMPARED>
            <MATCHED>0</MATCHED>
            <NOT_MATCHED>0</NOT_MATCHED>
            <ERROR>0</ERROR>
      </SQL_Analysis>
      <Data_Analysis>
            <NOT_COMPARED>0</NOT_COMPARED>
            <MATCHED>0</MATCHED>
            <NOT_MATCHED>1</NOT_MATCHED>
            <ERROR>0</ERROR>
      </Data_Analysis>
      <Graph_Analysis>
            <NOT_COMPARED>1</NOT_COMPARED>
            <MATCHED>0</MATCHED>
            <NOT_MATCHED>0</NOT_MATCHED>
            <ERROR>0</ERROR>
      </Graph_Analysis>
      <Excel_Analysis>
            <NOT_COMPARED>1</NOT_COMPARED>
            <MATCHED>0</MATCHED>
            <NOT_MATCHED>0</NOT_MATCHED>
            <ERROR>0</ERROR>
      </Excel_Analysis>
      <Pdf_Analysis>
            <NOT_COMPARED>1</NOT_COMPARED>
            <MATCHED>0</MATCHED>
            <NOT_MATCHED>0</NOT_MATCHED>
            <ERROR>0</ERROR>
      </Pdf_Analysis>
</Execution_Stats>
0
Hello,
I am trying to add a header and tabs with info about the XML data file to .xml file in SAS code. How exactly this can be done? Please see what I have currently I have for my SAS code. I can see the XML data file as my output but the Header (tab and tab2) with all info about the XML file does not show up yet in the XML file.
 
libname xmldir xmlv2 '/basepath/examples/XMLData.xml' xmltype=generic;

/* Req. 1: Macro variables to provide appropriate tab spacing. */
%let tab="    ";
%let tab2="        ";

/* Req. 2: XML file information and header*/
data _null_;
   file xmldir;
  
    put '<?xml version="1.0" encoding="UTF-8"?>';
    put '<Schema Name>';
    put &tab. '<Header>';
    put &tab2. '<SampleDate>2017-06-14</SampleDate>';
    put &tab2. '<CaseCount>30</CaseCount>';
    put &tab2. '<Action>Initial</Action>';
    put &tab2. '<YearPeriod>2017</YearPeriod>';
    put &tab. '</Header>';
    put &tab. '<Payload>';
run;

/* Req. 3: Writing two SAS datsets to xmldir library and creating XMLData.xml data file*/ 
data xmldir.dataname1(label="dataset name1 from sashelp library");
       set sashelp.dataset1(obs=10);
run;

data xmldir.dataname2(label="dataset name2 from sashelp library");
       set sashelp.dataset2(obs=20 keep=var1 var2); 
run; 

libname xmldir clear;

/* Req. 4: XML File End*/
data _null_;
   file xmldir mod;

    put &tab'<Payload>';
    put '</Schema Name>';
run;

Open in new window


So, currently only Req. 3 is working.
Any comments or suggestions will be greatly appreciated!
0
I have task that need me to read an xml file that has been given to me. I've made some research, unfortunately I didn't find one that suit with my needs. I am using javascript to read the xml file. Is there any ways on how can I read the xml file using ftp? Your help is greatly appreciated.
0
I think I know the answer to my question but I am asking it anyway (I know one is file  - xdDoc.Load and one is string xdDoc.LoadXml etc)
I have a variable that contains an XML formatted string.
Normally I would load XML from a file, using the following code:
	set xdDoc = Server.CreateObject("MSXML2.DOMDocument.6.0")
         xdDoc.load(strSource)

Open in new window


But the foregoing code fails when I use a XML string.
The following code works for the XML string and why is that??
AM I using the correct version for "Microsoft.XMLDOM"
I know I am okay with "MSXML2.DOMDocument.6.0"

   set xdDoc = CreateObject("Microsoft.XMLDOM") 
   xdDoc.LoadXml(strSource)

Open in new window

0
Hi,
  Using Access 2016   My xml ribbon is giving me an error on the line with :  SaveObjectAs, FileSaveAsCurrentFileFormat, FileOpen, TabNew, FileExit)
     Do not get these errors in 2010…
 Error:  
    Line:46
    Column: 14
    Error Code Ox80004005
    Failed to find Office control by ID
    ID: SaveObjectAs
Here is part of the  XML file:    
<tab idMso="TabInfo" visible="false"/>
    <tab idMso ="TabOfficeStart" visible="false"/>
    <button idMso="SaveObjectAs" visible="false"/>
    <button idMso="FileSaveAsCurrentFileFormat" visible="false"/>
    <button idMso="FileOpen" visible="false"/>
    <button idMso="FileCloseDatabase" visible="false"/>
    <tab idMso="TabRecent" visible="false"/>
    <tab idMso="TabNew" visible="false"/>
    <tab idMso="TabPrint" visible="false"/>
    <button idMso="FileCloseDatabase" visible="true"/>
    <tab idMso="TabHelp" visible="false"/>
    <button idMso="ApplicationOptionsDialog" visible="false"/>
    <button id = "OpenMainMenu" imageMso ="FileOpenDatabase" label = "Return to Main Menu" onAction = "OnButtonPress"  tag="MainMenu"/>    
    <button idMso="FileExit" visible="false" />

Thanks,
    Donna
0
I have made app with 6 datatables ,I can save in datagridview but it deletes when I close my app,now I need to know how to save in the file and reload it
0
Hello,

I am looking for a Data Field Mapping tool for DotNET that will provide XML-to-XML field mapping or DataTable to DataTable field mapping.  A GUI tool would be preferred.

The Altova MapForce product would be ideal, but I would like to review Open Source tools first.

Thanks for any ideas
0
Hi.  Below is a procedure (stripped down) that gives me an error when I "exec prTEST"
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[prTEST]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[prTEST]
GO
CREATE PROCEDURE [dbo].[prTEST]			
As
Begin
	-------------  these must be set as below for XML.nodes to work ...
	SET NOCOUNT ON
	SET ANSI_NULLS ON
	SET QUOTED_IDENTIFIER ON
	SET CONCAT_NULL_YIELDS_NULL ON
	SET ANSI_WARNINGS ON
	SET ANSI_PADDING ON
	SET ARITHABORT ON
	SET NUMERIC_ROUNDABORT OFF
	-------------

	DECLARE @TicketNo int							
	DECLARE @myXML    xml
	SET @myXML = '<Batch><Ticket>249392</Ticket></Batch>'

	SELECT @TicketNo   = x.v.value('Ticket[1]', 'int')
	FROM @myXML.nodes('/Batch') as x(v)
end
GO

Open in new window

When I do an "EXEC prTEST" I get the following error:  
Msg 1934, Level 16, State 1, Procedure prTEST, Line 19
SELECT failed because the following SET options have incorrect settings: 
'ANSI_NULLS, QUOTED_IDENTIFIER'.
Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations.

Open in new window

I have used similar code before, but don't recall getting this error.  Even when I do the SET in the query window with the EXEC I get the same error:
SET NOCOUNT ON
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET CONCAT_NULL_YIELDS_NULL ON
SET ANSI_WARNINGS ON
SET ANSI_PADDING ON
SET ARITHABORT ON
SET NUMERIC_ROUNDABORT OFF

EXEC prTEST

Open in new window

Any suggestions?
Thanks
0
Hello guys,

I have an xml file. I need to read all the contents of the tags in this xml and make the MD5 result. But I do not know how to do that.

The result of MD5 must be: 25bbb49c00aada5300c0607487eb54df


Help me please!!
TESTE_XML.xml
0
Learn by Doing. Anytime. Anywhere.
Learn by Doing. Anytime. Anywhere.

Do you like to learn by doing?
Our labs and exercises give you the chance to do just that: Learn by performing actions on real environments.

Hands-on, scenario-based labs give you experience on real environments provided by us so you don't have to worry about breaking anything.

I have a SOAP web service on another server and it returns XML as response when called from SOAP UI software.
I need to develop a web console application.
How can I input the XML directly into codes ?  

Please send me a sample code or tutorial.
0
Hi,

Trying to Convert BASE64 String to Float array.

Input : <values byteorder="INTEL" format="FLOAT32" numvalues="74">MsHjPwc65T/csuY/sSvoP4ak6T+9Les/CKzsP8kv7j8Uru8/6SbxPzWl8j/2KPQ/y6H1P4wl9z/X
o/g/mCf6PwuQ+z+R7fw/exT+P7QP/z+7AgBA/40AQFYOAUCGpAFA50ICQKrxAkCLswNAa3UEQEw3
BUAs+QVADbsGQDN6B0CdNghAfvgIQKO3CUDJdgpA7jULQBT1C0B+sQxAX3MNQIQyDkCq8Q5AFK4P
QH9qEEDpJhFAD+YRQHqiEkCfYRNACh4UQC/dFEBVnBVAelsWQKAaF0CA3BdA65gYQBBYGUB7FBpA
oNMaQAuQG0B1TBxAmwsdQHzNHUChjB5ADEkfQHYFIECcxCBAwYMhQCxAIkAMAiNA7cMjQFeAJEB9
PyVAov4lQA27JkA=

        </values>
        <Ydata label="Intensity" units="UNKNOWN">
          <values byteorder="INTEL" format="FLOAT32" numvalues="74">AGiERQBYCkYAwHNFAOi7RQCYyEUAQJBFAAw5RgCQQUUAwPZEAFjrRQAMo0YAbvBGAHtqRwDMzEdA
CCZIwD1mSGDanUig851IoFuNSODFpEgAQaRIQFurSIA2i0iAHW1IwD9/SMB/O0jADhRIALDOR4A5
wEcAIpxHADJaRwCkJ0cA9AxHAJbdRgBE4kYADKdGAJCGRgAUZEYA2E1GAIBMRgDAdEYAIK9FAOAB
RgAY8UUAiKxFADj7RQDwFkYAaOhFAIjMRQCcNEYAeM9FAGipRQDgokUA8HVFAEAzRQCgMEUAkL9F
AMgpRgDwxUUAWJhFAKAqRQDAA0YA0KlFAHBxRQBg4kUAMDlFAIBSRQB4k0UAKNFFAFQGRgDkGkYA
0AdFAIDARQBQt0U=

          </values>
Here want to convert the string inside the Values tag into Float Array.
If i would take value -
( MsHjPwc65T/csuY/sSvoP4ak6T+9Les/CKzsP8kv7j8Uru8/6SbxPzWl8j/2KPQ/y6H1P4wl9z/X
o/g/mCf6PwuQ+z+R7fw/exT+P7QP/z+7AgBA/40AQFYOAUCGpAFA50ICQKrxAkCLswNAa3UEQEw3
BUAs+QVADbsGQDN6B0CdNghAfvgIQKO3CUDJdgpA7jULQBT1C0B+sQxAX3MNQIQyDkCq8Q5AFK4P
0
I need a script to edit a parameter in multiple .XML files.

<DspsOpt>1|R^Y^Y|PPF44|Y</DspsOpt>

This line will always contain the number 1 at the start - however, I need a script to read the file and change the number to a 2 - and then move it to a different directory.

For example:

The file exists in  c:\originalfile

*file is changed to*

<DspsOpt>2|R^Y^Y|PPF44|Y</DspsOpt>

*file is moved to*

 c:\editedfile

To further complicate - if the file exists in c:\originalfile1

*file is changed to*

<DspsOpt>3|R^Y^Y|PPF44|Y</DspsOpt>

*file is moved to*

 c:\editedfile

Giving me the option to monitor multiple directories - and changing the original 1 with an alternative number based on what directory the original file is hosted in - most likely in sequence.

I need to be able to run this script with windows scheduler.

I have uploaded an XML file that I will be working with to give you an idea :)

I appreciate any help you guys can give.

Regards

Wayne
1496396056001.xml
0
I have been tasked with integrating a site that collects gift orders with our job workflow software.  We are using PressWise for our workflow, and they allow SOAP encapsulated XML calls to a WSDL service.

I have got the XML document creation finished, but I can't really seem to even begin on the SOAP.  I am using PHP for the project, and I know that PHP supports SOAP, but no examples that I have tried have worked, so far.

Here is what the XML document looks like:
<?xml version="1.0"?>
<data>
  <customerID>1232</customerID>
  <userID>5325</userID>
  <sourceOrderID>1</sourceOrderID>
  <quoteName>1 line items</quoteName>
  <shipTo>
    <stNameCompany/>
    <stAttention>John Smith</stAttention>
    <stAddress2/>
    <stStreet>1180 Dillerville Road</stStreet>
    <stCity>Lancaster</stCity>
    <stState>PA</stState>
    <stZip>17601</stZip>
    <stCountry>US</stCountry>
    <avsResidential/>
    <shipCost>0</shipCost>
    <shipMethod>FedEx Ground</shipMethod>
  </shipTo>
  <item>
    <productID>Desk Set</productID>
    <quantity>1</quantity>
    <productType>Inventory</productType>
    <sourceJobID>123</sourceJobID>
    <memo>Gift Order# 123</memo>
    <customerApproval>accepted</customerApproval>
    <price>0</price>
  </item>
</data>

Open in new window


Here's what I need the final data to look like:
<?xml version="1.0" encoding="UTF-8"?>
<SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" 

Open in new window

0
Hi,
I am very new in VBA and need help. Found your function and its seams almost what i need.
I have access field with xml data like :
<?xml version = "1.0" encoding="Windows-1250" standalone="yes"?>
<VFPData>
      <row docisprod="false" itemnum="0" doctype="N380" docref="26/13" complinf=""/>
      <row docisprod="false" itemnum="0" doctype="N864" docref="IZJAVA O PODRIJETLU" complinf=""/>
      <row docisprod="false" itemnum="0" doctype="Y900" docref="NIJE PREDMET WK" complinf=""/>
</VFPData>
Need to extract values in separated query columns like column field ="doctype "value="N380" ;column field= "docref" value="26/13"...
Tried with GetNode()  function, but for me not working. Using access 2013.
Any help will be appreciated.
Thanks,

Reference and similar solution:
split XML field into many fields from MS Access
Posted on 2017-02-21
https://www.experts-exchange.com//questions/29003958/split-XML-field-into-many-fields-from-MS-Access.html
0
Hi. I'm having input xml file, which having double quotes attribute, But i want to change as single quote while doing xml to json process. because json files not allowing double quotes:

My input xml file having:

                  <div class="text-center">
                     <p>
                        <strong> Type:</strong> Unhealthy fat</p>
                  </div>

for Json output I need as:

                  <div class='text-center'>
                     <p>
                        <strong> Type:</strong> Unhealthy fat</p>
                  </div>

I'm using saxon-PE 9.6.0.7 and XSLT version as 3.0. How i can change the double quote to single quote??
0

XML

20K

Solutions

9

Articles & Videos

13K

Contributors

Extensible Markup Language (XML) refers to the encoding of documents such that they can be read by both machines and humans. XML documents use tags to show the beginning and end of a set of data. XML is used extensively on websites to show volumes of data, and is the default for a number of office productivity suites. This topic includes discussions of XML-related technologies, such as XQuery (the XML Query language), XPath (the XML Path language), XSLT (eXtensible Stylesheet Language Transformations), XLink (the XML Linking language) and XPointer (the XML Pointer language).