XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » Stylus Studio Technical Forum » Modifying Field Name in XML
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> - Overly complicated formatting ... (1)
-> + java apparently running, canno... (2)
-> + Stylus on Citrix - unable to v... (6)
-> + XSLT and XPath Questions (New ... (13)
-> + EDIFACT D96A CONTRL XML schema (2)
-> + JDK dropdown box empty and Jav... (2)
-> + Replacing XSD files in Report (4)
-> + Cannot locate WYSIWIG tab on X... (3)
-> + EDI X12 xml schema with segmen... (2)
-> + Error Message (4)
-> + jvm disabled message keeps pop... (2)
-> + XTSE0620: An xsl:param element... (3)
-> + Fail in installing “Apache FOP... (5)
-> - Jenkins: about the path of bui... (1)
-> + problem with Stylus X15 XML RE... (2)
-> + Cannot remove a row into a tab... (6)
-> + prevent the meta data from bei... (3)
-> + Unable to auto detect JRE in X... (2)
-> - Unable to auto detect JRE in X... (1)
-> - where to find information (1)
-- [1-20] [21-40] [41-60] 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  
Postnext
Ivan PedruzziSubject: 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
Postnext
Ivan PedruzziSubject: 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
Postnext
Ivan PedruzziSubject: 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
Posttop
Ivan PedruzziSubject: 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
   
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! 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

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
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.