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)
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)
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)
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)
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)
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)
StylusValidator.exe Command Li...
(3)
Cannot run Java built in valid...
(2)
Windows 10???
(3)
Stylus Custom XML Conversion (...
(8)
X14 enterprise and saxon 9.4.0...
(3)
Open an XML document in the XM...
(3)
How to generate mapping report...
(4)
[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
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.