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
Mitchell SprinskySubject: CSV conversion with null field
Author: Mitchell Sprinsky
Date: 08 Jun 2009 09:32 AM
I am trying to convert a CSV file with multiple columns. Most of the time, the second address field is blank. When the file is converted, address2 comes out as <address2/>. How do I get the system to convert it as it does all the other fields? So, if address2 is blank, the xml file would still have <address2></address2>.


Example:

Currently:

<table>
<row>
<DEA>555555555</DEA>
<First_Name>JOHN</First_Name>
<Last_Name>SMITH</Last_Name>
<HMS_POID>XXXXXXXX</HMS_POID>
<Acct_Name>BIG HOSPITAL</Acct_Name>
<Acct_Address1>4444 HOSPITAL WAY</Acct_Address1>
<Acct_Address2/>
<Acct_City>FORT LAUDERDALE</Acct_City>
<Acct_State>FL</Acct_State>
<Acct_Zip>33308</Acct_Zip>
<Phys_Acct_Rank>1</Phys_Acct_Rank>
<Workload>>50%</Workload>
<Workload_Rank>1</Workload_Rank>
</row>
</table>

Should be:

<table>
<row>
<DEA>555555555</DEA>
<First_Name>JOHN</First_Name>
<Last_Name>SMITH</Last_Name>
<HMS_POID>XXXXXXXX</HMS_POID>
<Acct_Name>BIG HOSPITAL</Acct_Name>
<Acct_Address1>4444 HOSPITAL WAY</Acct_Address1>
<Acct_Address2></Acct_Address2>
<Acct_City>FORT LAUDERDALE</Acct_City>
<Acct_State>FL</Acct_State>
<Acct_Zip>33308</Acct_Zip>
<Phys_Acct_Rank>1</Phys_Acct_Rank>
<Workload>>50%</Workload>
<Workload_Rank>1</Workload_Rank>
</row>

Postnext
Ivan PedruzziSubject: CSV conversion with null field
Author: Ivan Pedruzzi
Date: 08 Jun 2009 10:28 AM
Hi Mitchell,

For an XML parser there is no difference between

<Acct_Address2/> and <Acct_Address2></Acct_Address2>

Can you tell us why this is creating problem for you?

Thanks
Ivan Pedruzzi
Stylus Studio Team

Posttop
Mitchell SprinskySubject: CSV conversion with null field
Author: Mitchell Sprinsky
Date: 08 Jun 2009 10:31 AM
>Hi Mitchell,
>
>For an XML parser there is no
>difference between
>
><Acct_Address2/> and
><Acct_Address2></Acct
>_Address2>
>
>Can you tell us why this is
>creating problem for you?
>
>Thanks
>Ivan Pedruzzi
>Stylus Studio Team

Thanks for the fast reply. The problem is with my Vendor who is trying to import our data into the new CRM system. She is insisting that it be tagged with an open and close. I think she understands XML about as much as I do -- not much.

 
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.