xlate

GCC Consulting rkreiss at gccconsulting.net
Tue Feb 19 14:56:28 PST 2013


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





More information about the Filepro-list mailing list