View Single Post
  #1 (permalink)  
Old October 20th, 2006, 10:46 AM
hugoscp hugoscp is offline
Authorized User
 
Join Date: Sep 2006
Location: , , .
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default Help in instruction string-replace

Can someone help me in the instruction string-replace.
I have this xml file:

<?xml version="1.0" encoding="ISO-8859-1" ?>
 <Order xmlns:xsd="http://www.w3.org/2000/10/XMLSchema">
 <OrderHead>
 <Schema>
  <Version>1</Version>
  </Schema>
 <MessageReferences>
  <MessageID>OCP326</MessageID>
  <MessageDate>2006-09-19 10:00</MessageDate>
  </MessageReferences>
  <OrderType Code="220" />
 <OrderCurrency>
  <Currency Code="EUR" />
  </OrderCurrency>
  </OrderHead>
 <OrderReferences>
  <BuyersOrderNumber>M.CEEX060913.014</BuyersOrderNumber>
  </OrderReferences>
  <OrderDate>2006-09-18 00:00</OrderDate>
 <Sender>
 <SenderReferences>
  <GLN>PT5003648774470573</GLN>
  </SenderReferences>
  </Sender>
 <Receiver>
 <ReceiverReferences>
  <GLN>PT5002232382790476</GLN>
  </ReceiverReferences>
  </Receiver>
 <Supplier>
 <SupplierReferences>
  <TaxNumber>PT500223238</TaxNumber>
  <GLN>PT5002232382790476</GLN>
  </SupplierReferences>
  </Supplier>
 <Buyer>
 <BuyerReferences>
  <TaxNumber>PT500364877</TaxNumber>
  <GLN>PT5003648774470573</GLN>
  </BuyerReferences>
  </Buyer>
 <Delivery>
 <DeliverTo>
 <DeliverToReferences>
  <GLN>PT5003648774470573</GLN>
  </DeliverToReferences>
  <Party>OCP - MAIA</Party>
 <Address>
  <Street>Rua do Barr!eiro, 179</Street>
  <City>Maia</City>
  <PostCode>4470-573</PostCode>
  <Country Code="PT" />
  </Address>
  </DeliverTo>
  </Delivery>
 <InvoiceTo>
 <InvoiceToReferences>
  <TaxNumber>PT500364877</TaxNumber>
  <GLN>PT5003648774470573</GLN>
  </InvoiceToReferences>
  </InvoiceTo>
 <OrderLine>
  <LineNumber>1</LineNumber>
 <OrderLineReferences>
  <TypeOfDestinationMarket>A</TypeOfDestinationMarket>
  </OrderLineReferences>
 <Product>
  <TradeUnitCode>5091889</TradeUnitCode>
  <Description>DIFFERIN CREME 0,1% 60GR.</Description>
  </Product>
 <Quantity>
  <Amount UOMCode="PCE">110!.0000</Amount>
  </Quantity>
 <Price>
  <UnitPrice UOMCode="PCE">782.000000</UnitPrice>
  </Price>
 <Delivery>
  <LatestAcceptableDate>2006-09-13 00:00</LatestAcceptableDate>
  </Delivery>
  </OrderLine>
 <OrderLine>
  <LineNumber>2</LineNumber>
 <OrderLineReferences>
  <TypeOfDestinationMarket>A</TypeOfDestinationMarket>
  </OrderLineReferences>
 <Product>
  <TradeUnitCode>5091780</TradeUnitCode>
  <Description>DIFFERIN GEL 0,1% 60GR.</Description>
  </Product>
 <Quantity>
  <Amount UOMCode="PCE">220.0000</Amount>
  </Quantity>
 <Price>
  <UnitPrice UOMCode="PCE">1656.000000</UnitPrice>
  </Price>
 <Delivery>
  <LatestAcceptableDate>2006-09-13 00:00</LatestAcceptableDate>
  </Delivery>
  </OrderLine>
 <OrderTotal>
  <NumberOfLines>2</NumberOfLines>
  </OrderTotal>
  </Order>

I would like to replace in the Order the ! caracter by a backspace.

Can someone help me please.

Reply With Quote