xlate

[GCC Consulting]

From: Ken Cole [mailto:ken.m.cole at gmail.com] 
Sent: Tuesday, February 19, 2013 6:06 PM
To: GCC Consulting
Cc: filepro-list at lists.celestial.com
Subject: Re: xlate

 

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

As far as I can see there are no other spaces.

 

Richard

 

 

 

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/20130219/d975ec6c/attachment.html