Richard,<br><br>Is this the only space in the XML file? That xlate command will remove all spaces in the XML and that may be breaking something else.<br><br>Regards<br><br>Ken<br><br><div class="gmail_quote">On Wed, Feb 20, 2013 at 9:56 AM, GCC Consulting <span dir="ltr">&lt;<a href="mailto:rkreiss@gccconsulting.net" target="_blank">rkreiss@gccconsulting.net</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">My program reads in an xml file and parses it.  The parsing program worked<br>
fine until it hit an element with no value except a blank space. Since I<br>
have a counter, when the counter hits this tag, I force my pointer to move<br>
to the next tag.  Not the best way to program.<br>
<br>
I considered using xlate to remove the blank space:<br>
<br>
        QQ=xlate(ab,&quot; &quot;,&quot;&quot;);ab=qq<br>
<br>
I used a msgbox to show the value of ab and the space had been removed.<br>
However, the parsing now completely fails.  Anyone have any idea why once<br>
xlate has been executed, my program fails but without it, everything works<br>
as programmed.<br>
<br>
Here is the xml string imported&quot;<br>
<br>
The problem is at the &lt;CVV2RespCode &gt;  &lt;/CVV2RestCode&gt;  note the space.  All<br>
other null tags are &gt;&lt;/ - no space<br>
<br>
&lt;?xml version=&quot;1.0&quot;<br>
encoding=&quot;UTF-8&quot;?&gt;&lt;Response&gt;&lt;NewOrderResp&gt;&lt;IndustryType&gt;&lt;/IndustryType&gt;&lt;Mess<br>
ageType&gt;AC&lt;/MessageType&gt;&lt;MerchantID&gt;700000005283&lt;/MerchantID&gt;&lt;TerminalID&gt;001<br>
&lt;/TerminalID&gt;&lt;CardBrand&gt;VI&lt;/CardBrand&gt;&lt;AccountNum&gt;4788250000028291&lt;/AccountN<br>
um&gt;&lt;OrderID&gt;3&lt;/OrderID&gt;&lt;TxRefNum&gt;50F9A73E14023D0549E816380965D4C50FB95327&lt;/T<br>
xRefNum&gt;&lt;TxRefIdx&gt;1&lt;/TxRefIdx&gt;&lt;ProcStatus&gt;0&lt;/ProcStatus&gt;&lt;ApprovalStatus&gt;1&lt;/A<br>
pprovalStatus&gt;&lt;RespCode&gt;00&lt;/RespCode&gt;&lt;AVSRespCode&gt;N8&lt;/AVSRespCode&gt;&lt;CVV2RespC<br>
ode&gt;<br>
&lt;/CVV2RespCode&gt;&lt;AuthCode&gt;095605&lt;/AuthCode&gt;&lt;RecurringAdviceCd&gt;&lt;/RecurringAdvi<br>
ceCd&gt;&lt;CAVVRespCode&gt;&lt;/CAVVRespCode&gt;&lt;StatusMsg&gt;Approved&lt;/StatusMsg&gt;&lt;RespMsg&gt;&lt;/<br>
RespMsg&gt;&lt;HostRespCode&gt;00&lt;/HostRespCode&gt;&lt;HostAVSRespCode&gt;M&lt;/HostAVSRespCode&gt;&lt;<br>
HostCVV2RespCode&gt;&lt;/HostCVV2RespCode&gt;&lt;CustomerRefNum&gt;&lt;/CustomerRefNum&gt;&lt;Custom<br>
erName&gt;&lt;/CustomerName&gt;&lt;ProfileProcStatus&gt;&lt;/ProfileProcStatus&gt;&lt;CustomerProfil<br>
eMessage&gt;&lt;/CustomerProfileMessage&gt;&lt;RespTime&gt;144918&lt;/RespTime&gt;&lt;PartialAuthOcc<br>
urred&gt;&lt;/PartialAuthOccurred&gt;&lt;RequestedAmount&gt;&lt;/RequestedAmount&gt;&lt;RedeemedAmou<br>
nt&gt;&lt;/RedeemedAmount&gt;&lt;RemainingBalance&gt;&lt;/RemainingBalance&gt;&lt;CountryFraudFilter<br>
Status&gt;&lt;/CountryFraudFilterStatus&gt;&lt;IsoCountryCode&gt;&lt;/IsoCountryCode&gt;&lt;/NewOrde<br>
rResp&gt;&lt;/Response&gt;<br>
<br>
<br>
<br>
Richard Kreiss<br>
GCC Consulting<br>
<br>
Office: 410-653-2813<br>
<br>
<br>
<br>
_______________________________________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a><br>
Subscribe/Unsubscribe/Subscription Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" target="_blank">http://mailman.celestial.com/mailman/listinfo/filepro-list</a><br>
</blockquote></div><br>