XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext 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.

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
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.