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 » XML converter "omit fields when missing or zero" question
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + SS says my trial has expired -... (2)
-> + XSD input; SQL Table Output Ne... (2)
-> + Building Schema from XML (2)
-> + conditions on tag values expre... (3)
-> - XML converter "omit fields whe... (3)
-> ->XML converter
-> ->XML converter
-> + Marklogic XQuery support in St... (2)
-> + XSL switching stylesheet from ... (10)
-> + Maximum recursion depth exceed... (3)
-> + How do I develop the server si... (2)
-> + XSD Reuse (2)
-> + what happened to my preview re... (3)
-> + How do I use the Custom XML Co... (4)
-> + WYSIWYG missing in release 2 o... (2)
-> + space between elements (3)
-> + Oracle XML Gateway output CONV... (6)
-> + Someone please help me install... (5)
-> + XML Schema (XSD) to COBOL Data... (2)
-> + Can't compile Java (9)
-> + Trouble using the UDDI Browser (5)
-> + JVM Problem when installing Ar... (2)
-- Previous [1381-1400] [1401-1420] [1421-1440] 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
Leigh WaltonSubject: XML converter "omit fields when missing or zero" question
Author: Leigh Walton
Date: 12 Oct 2007 12:11 PM
I am converting a flat file specifing beginning column locations to form the xml field elements. Does the "omit from output only when blank or zero" specification work on a record basis or a file basis? I am trying to selectively exclude fields in a records where the field contains zeros. The resulting xml would have this field included for some records but not others. The converter does not omit fields with zeros.
Postnext
Tony LavinioSubject: XML converter
Author: Tony Lavinio
Date: 15 Oct 2007 12:14 AM
It should omit fields with blank or zero values. It
is on a per-field basic (meaning it is checked for each
field within each record).

Which version are you using? Can you post a testcase,
or email it to stylus-field-report (at) progress.com?
Posttop
Tony LavinioSubject: XML converter
Author: Tony Lavinio
Date: 15 Oct 2007 10:01 AM
(After a brief off-line exchange, here is the answer to the above:)

Here is the issue: the fields 'other_codes' are defined as 'String',
and certainly '0000000000' is not '0' or ''. So they are not selected
as elements to exclude.

You could define them as 'Number', but that wouldn't work too well,
since they are not numerical values.

But... you can use the 'Lookup List' property. Click on the value
space next to 'Lookup List' and a dialog comes up. In the left-hand
side, put '0000000000' and leave the right-hand side empty. This
will translate any occurrences of '0000000000' to ''.

Now, the 'Omit from Output' exclusion logic, which looks at the
result AFTER the application of the lookup list, will kick in.

   
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.