title: Best way to convert ASCII txt file to XML within VB.NET, C# or Javascript?
body: <p>I'm not exactly sure if this is the correct question to be asked but I will tell you what I am attempting.  I have an ASCII txt file with product data in it.  It does not have headers.  I am looking for a way to convert this data into an XML file, however, I want it to parse through one of the txt fields to incorporate a look-up field and modify the data based on that field.  Now I could use VB.NET, C# or Javascript. Example provided:</p>
  
  <p>Example ASCII Data:</p>
  
  <pre><code>ACE14       1016    ACP, Inc.   Amana® Commercial Convection Express™ Combination Oven
  AOC24       1016    ACP, Inc.   Amana® Commercial Microwave Oven, 2400 watts
  </code></pre>
  
  <p>Example XML I need based off example given (it would look up info based on 'ACP, Inc.')</p>
  
  <pre><code>&lt;xml&gt;
    &lt;Product&gt;
       &lt;ProductManufacturer&gt;ACP, Inc.&lt;/ProductManufacturer&gt;
       &lt;ProductCode&gt;AMN-ACE14&lt;/ProductCode&gt;
       &lt;ProductTitle&gt;Amana Commercial Convection Express Combination Oven&lt;/ProductTitle&gt;
    &lt;/Product&gt;
  &lt;Product&gt;
       &lt;ProductManufacturer&gt;ACP, Inc.&lt;/ProductManufacturer&gt;
       &lt;ProductCode&gt;AMN-AOC24&lt;/ProductCode&gt;
       &lt;ProductTitle&gt;Amana Commercial Microwave Oven&lt;/ProductTitle&gt;
    &lt;/Product&gt;
  </code></pre>
  
  <p>Anyone direct me to some good samples?  It would give me a good start.  Thanks.</p>