xlate

[Ken Cole]

Richard,

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.

Regards

Ken

On Wed, Feb 20, 2013 at 9:56 AM, GCC Consulting
<rkreiss at gccconsulting.net>wrote:

> My program reads in an xml file and parses it.  The parsing program worked
> fine until it hit an element with no value except a blank space. Since I
> have a counter, when the counter hits this tag, I force my pointer to move
> to the next tag.  Not the best way to program.
>
> I considered using xlate to remove the blank space:
>
>         QQ=xlate(ab," ","");ab=qq
>
> I used a msgbox to show the value of ab and the space had been removed.
> However, the parsing now completely fails.  Anyone have any idea why once
> xlate has been executed, my program fails but without it, everything works
> as programmed.
>
> Here is the xml string imported"
>
> The problem is at the <CVV2RespCode >  </CVV2RestCode>  note the space.
>  All
> other null tags are ></ - no space
>
> <?xml version="1.0"
>
> encoding="UTF-8"?><Response><NewOrderResp><IndustryType></IndustryType><Mess
>
> ageType>AC</MessageType><MerchantID>700000005283</MerchantID><TerminalID>001
>
> </TerminalID><CardBrand>VI</CardBrand><AccountNum>4788250000028291</AccountN
>
> um><OrderID>3</OrderID><TxRefNum>50F9A73E14023D0549E816380965D4C50FB95327</T
>
> xRefNum><TxRefIdx>1</TxRefIdx><ProcStatus>0</ProcStatus><ApprovalStatus>1</A
>
> pprovalStatus><RespCode>00</RespCode><AVSRespCode>N8</AVSRespCode><CVV2RespC
> ode>
>
> </CVV2RespCode><AuthCode>095605</AuthCode><RecurringAdviceCd></RecurringAdvi
>
> ceCd><CAVVRespCode></CAVVRespCode><StatusMsg>Approved</StatusMsg><RespMsg></
>
> RespMsg><HostRespCode>00</HostRespCode><HostAVSRespCode>M</HostAVSRespCode><
>
> HostCVV2RespCode></HostCVV2RespCode><CustomerRefNum></CustomerRefNum><Custom
>
> erName></CustomerName><ProfileProcStatus></ProfileProcStatus><CustomerProfil
>
> eMessage></CustomerProfileMessage><RespTime>144918</RespTime><PartialAuthOcc
>
> urred></PartialAuthOccurred><RequestedAmount></RequestedAmount><RedeemedAmou
>
> nt></RedeemedAmount><RemainingBalance></RemainingBalance><CountryFraudFilter
>
> Status></CountryFraudFilterStatus><IsoCountryCode></IsoCountryCode></NewOrde
> rResp></Response>
>
>
>
> Richard Kreiss
> GCC Consulting
>
> Office: 410-653-2813
>
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20130220/c3af9d88/attachment.html