UNIX for Dummies Questions & Answers

  <Data DataNodeName="Rpt_CrossCcyRates" DataType="XML">
  <Rpt_CrossCcyRates xmlns="urn:schemas.reval.com:repCrossCcy">
  <CrossCcyDef>
    <CreateDate>2012-08-31 02:10:54</CreateDate> 
    <RateSource>1</RateSource> 
    <QuoteType>3</QuoteType> 
    <FromCcy>AED, AMD, ARS, AUD, BBD, BGN, BHD, BND, BRL, BRO, CAD, CHF, CLP, CNH, CNO, CNY, COP, CRC, CYP, CZK, DKK, DOP, DZD, EEK, EGP, EUR, FJD, GBP, GTQ, GYD, HKD, HNL, HRK, HUF, IDO, IDR, ILS, INR, IQD, ISK, JOD, JPY, KES, KRW, KWD, KZT, LBP, LKR, LTL, LVL, MAD, MKD, MOP, MTL, MUR, MXN, MYO, MYR, MZN, NOK, NZD, OMR, PEN, PGK, PHO, PHP, PKR, PLN, QAR, RON, RSD, RUB, SAR, SEK, SGD, SKK, THB, THO, TND, TRL, TRY, TTD, TWD, TWO, UAH, USD, UYU, VEB, VEF, VND, XAF, XPF, YER, ZAR</FromCcy> 
    <ToCcy>USD</ToCcy> 
    <StartDate>2012-08-31</StartDate> 
    <EndDate>2012-08-31</EndDate> 
    <Interval>Daily</Interval> 
    <ApplyMktConv>1</ApplyMktConv> 
  </CrossCcyDef>

  </Rpt_CrossCcyRates>
  </Data>

sed -n -e '/<\?xml .* \?>/p' original.xml > header.xml

sed -n -e '/<CrossCcyRates>/,/<\/CrossCcyRates>/p' original.xml >> header.xml

sed 's/.*<\/CrossCcyDef>//;s/<\/Rpt_CrossCcyRates>//;/^[ \t]*<\/Data>[ \t]*$/d' original.xml > required.xml