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)
Problem with SAXO processor - ...
(5)
PDF Format Help
(4)
License check unreliable
(3)
XML related issue
(1)
Need help regarding pipeline o...
(2)
Error converting XML to EDIFAC...
(4)
XSLT Profiling for XSLT 1.0 s...
(2)
Grouping
(2)
Best Practice for Pipeline err...
(2)
pdf generation
(4)
Problems excuting a Pipeline w...
(2)
XML serializer
(3)
Supported EDIFACT versions
(5)
Anyone know XActimate ESX file...
(1)
Stylus Studio with OpenJDK
(2)
Encoding error when importing ...
(1)
SEO Service in Delhi, India
(1)
HP Printer Support
(1)
Stylus Studio X16 Professional...
(5)
Stylus Studio X16 Enterprise -...
(4)
[1-20]
[21-40]
[41-60]
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.