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)
How to disable checking for up...
(2)
XML Publisher requires duplica...
(4)
Modifying Field Name in XML
(4)
Modifying Field Name in X...
Modifying Field Name in X...
Modifying Field Name in X...
Java Runtime Environmnet Libra...
(2)
Passing Parameters and Multipl...
(4)
Total Newbie Question... where...
(3)
XML Pipeline
(2)
Encoding problem in text previ...
(5)
New Installation on windows 20...
(4)
Exception while calling Java m...
(1)
Jars to be included for callin...
(2)
SXXP0003: Error reported by XM...
(2)
Validation error
(5)
Windows 10, latest Java, new t...
(2)
using help crashes stylus stud...
(3)
Web Service Call error
(5)
javax.xml.xquery.XQException: ...
(2)
Trang translator is not availa...
(2)
Replacement for flat2xml
(2)
CONV CSV Display Problem
(3)
Previous
[61-80]
[81-100]
[101-120]
Next
Website Feedback
(249)
XSLT Help and Discussion
(7625)
XQuery Help and Discussion
(2017)
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.