Sign Up
Search
Options
search
Chat
Help
News
Log in
Not Logged in
Home
»
Boards
»
Stylus Studio Developer Network
»
Stylus Studio Technical Forum
»
Modifying Field Name in XML
Conferences
Stylus Studio Feature Requests
(1192)
Stylus Studio Technical Forum
(14621)
X16 - XPath 3.0, XQuery 3.0, X...
(2)
Test
(1)
XSLT debugger shows [symbol u...
(3)
How do i use *.conv to process...
(1)
How do i use *.conv to process...
(1)
Not able to configure JVM in ...
(5)
Converting Cobol flat file to ...
(2)
Problem with uninstall - Windo...
(2)
Function current() is not reco...
(6)
API or web version
(2)
How to use Saxon for X16 on WI...
(9)
Error in SS X14 syntax highlig...
(2)
Option not available
(2)
XML Diff functionality and sor...
(3)
Convert Oagis XML file to TXT
(4)
DataDirect xqresultsequence is...
(2)
xfile Legacy file format suppo...
(1)
TPFDF
(3)
Help needed with SLSRPT - EDIF...
(2)
keeps crashing after I try and...
(1)
Previous
[61-80]
[81-100]
[101-120]
Next
Website Feedback
(249)
XSLT Help and Discussion
(7625)
XQuery Help and Discussion
(2016)
Stylus Studio FAQs
(159)
Stylus Studio Code Samples & Utilities
(364)
Stylus Studio Announcements
(113)
Topic
next
Subject:
Modifying Field Name in XML
Author:
Ivan Pedruzzi
Date:
07 Apr 2016 04:11 PM
Chandrasekhar,
Which Stylus Studio version are you running?
Can you show an example of the input XML fragment with the space?
Ivan Pedruzzi
Stylus Studio Team
next
Subject:
Modifying Field Name in XML
Author:
Ivan Pedruzzi
Date:
07 Apr 2016 06:16 PM
The problem is in your JSON to XML conversion. Once the XML is broken, you cannot parse/fix it with XSLT or XQuery.
How you do convert JSON to XML?
Stylus Studio JSON to XML Converter does the right thing, here an example of URL
converter:JSON:root=root?file:///c:/temp/gps.json
and the resulting XML
<root>
<version>1.00</version>
<type>Fault Codes</type>
<companyId>57</companyId>
<faultcodeType>0</faultcodeType>
<sentDateTime>06/13/12 01:12:40</sentDateTime>
<vehicleNumber>1565B</vehicleNumber>
<VIN>ABCDE123456789012</VIN>
<DSN>1114645</DSN>
<pfmDriverId>1234567</pfmDriverId>
<fc_Mid>128</fc_Mid>
<fc_pid_sidIndicator>0</fc_pid_sidIndicator>
<fc_Code>298</fc_Code>
<fc_SA/>
<fc_spn/>
<fc_fmi>0</fc_fmi>
<triggerDate>06/04/12 20:35:27</triggerDate>
<urgentFlag>0</urgentFlag>
<fc_odometer>59078</fc_odometer>
<fc_rpm>1373</fc_rpm>
<fc_speed>63</fc_speed>
<occurrenceCount/>
<cruiseStatus>0</cruiseStatus>
<ignitionStatus>1</ignitionStatus>
<GPS_Quality>1</GPS_Quality>
<latitude>44.9216948</latitude>
<longitude>-93.4490898</longitude>
</root>
Ivan Pedruzzi
Stylus Studio Team
next
Subject:
Modifying Field Name in XML
Author:
Ivan Pedruzzi
Date:
07 Apr 2016 07:17 PM
You may consider to adopt our technology for converting JSON to XML.
Let us know if you want learn more.
Ivan Pedruzzi
Stylus Studio Team
top
Subject:
Modifying Field Name in XML
Author:
Ivan Pedruzzi
Date:
07 Apr 2016 08:36 PM
As long as the XML is well-formed you can use XSLT to reshape it
Ivan Pedruzzi
Stylus Studio Team
Powered by
Stylus Studio
, the world's leading
XML IDE
for
XML
,
XSLT
,
XQuery
,
XML Schema
,
DTD
,
XPath
,
WSDL
,
XHTML
,
SQL/XML
, and
XML Mapping
!
Go to Conference:
Select Conference
Stylus Studio Feature Requests
Stylus Studio Technical Forum
Website Feedback
XSLT Help and Discussion
XQuery Help and Discussion
Stylus Studio FAQs
Stylus Studio Code Samples & Utilities
Stylus Studio Announcements
go
Log In Options
Username:
Password:
Site Map
|
Privacy Policy
|
Terms of Use
|
Trademarks
Stylus Scoop XML Newsletter:
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.