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)
-> + Can SS do this? (14)
-> - CargoImp support (1)
-> + No Preview Displayed - File is... (3)
-> - Stylus Studio X16 build 1974l ... (1)
-> + Help! Help!Help! Regading form... (2)
-> + FileNotFoundException generati... (6)
-> + FO External Graphic Producing ... (2)
-> + Use of Java methodes (4)
-> + get generated XQuery output on... (2)
-> - right construct for involving ... (1)
-> + SS JRE Version has "Stylus Stu... (3)
-> + Trying to validate an XSD: co... (3)
-> + Disable "Output" windows (4)
-> + Stylus Studio V16 X64 update d... (2)
-> + Could not load the Java Virtua... (2)
-> + .NET XslCompileTransform strip... (6)
-> + XML Report Preview and Save Ev... (8)
-> + X16 Enterprise 32bit crash on ... (5)
-> - MSXML6.0 SAX Parser, "Index re... (1)
-> + MSXML6.0 DOM Parser stops afte... (4)
-- 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  
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.