Extract cost model information for use in Excel or Access

Dave,

I used the TML file and converted all the cost entries by target locale into a single row of comma separated values

The TML has a block of data loke the following for each language:

<costModelLocale>
        <localeRef>Arabic (Saudi Arabia)</localeRef>
        <ice>0.0</ice>
        <perfect>0.0</perfect>
        <repetition>0.04</repetition>
        <rangeWordPrices>
          <price>0.225</price>
          <price>0.135</price>
          <price>0.09</price>
          <price>0.09</price>
        </rangeWordPrices>
      </costModelLocale>

Using notepad ++ and a series of regular expression replacements to create the following result:

Arabic (Saudi Arabia),0.0,0.0,0.04,0.225,0.135,0.09,0.09

The set of replacement operations using the regular expression find and replace in notepad++ are:

\r\s*<price> <-- <price>
\r\s* <--
\r\s*<repetition> <-- <repetition>
\r\s*<perfect> <-- <perfect>
\r\s*<ice> <-- <ice>
</[^>]*?> <-- no value to remove such entries
delete       <costModelLocale>
\s*<localeRef>  <-- no value to remove such entries
 <-- no value to remove such entries

<[^>]*?> <-- ,

The line  <-- no value to remove such entries should be <rangeWordPrices> <-- no value to remove such entries

The line \r\s* <--  should be replaced with \r\s*<rangeWordPrices> <-- <rangeWordPrices>

Thank you so much for this Larry! I'll pass that on here and there will be much rejoicing!