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)
-> - XML Report - Horizontal Line (1)
-> + XML feed to a txt file (2)
-> + problem with xml output (2)
-> + XSL Debugging (2)
-> + XML schema validation issue (t... (2)
-> + Problem during saving styleshe... (4)
-> + Slow Redraw (11)
-> + Source XML code updates in map... (2)
-> + converting XML to Excel (2)
-> + Pre-Sales Questions? And Mergi... (2)
-> + How can I download an earlier ... (2)
-> + Create multiple string outputs... (2)
-> + Alternate page masters indepen... (3)
-> + Flat to XML and back with Styl... (2)
-> + BUG: Byte Order Mark inserted ... (2)
-> + Schema Validation using the to... (7)
-> + Flat Text file to XML or XSD (6)
-> + Second time it should not go i... (2)
-> + How to sum Nodes which are at ... (2)
-> + Where has the wysiwyg editor g... (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.