title: Split line of text at pre-defined markers
body: <p>I apologize if this has been done but I'm up to two days of searching now for what i'd hoped would be a simple solution without success</p>
  
  <p>I have a file that has 100 rows of data in it.</p>
  
  <p>Each row has 380 characters.</p>
  
  <p>I have a guide that tells me:</p>
  
  <blockquote>
    <p>starting at character 1, for 3 characters is information x</p>
    
    <p>starting at character 4, for 8 characters is information y</p>
    
    <p>starting at character 12, for 16 characters is information z</p>
    
    <p>etc</p>
  </blockquote>
  
  <p>For what is effectively 43 columns of information jammed into one block. Some information is names, dates, numbers that have 2 decimal places, numbers that have 8 decimal places etc.</p>
  
  <p>E.G. </p>
  
  <pre><code>MJBN1XXXXXX00018YNN1C11010C  SMITH JOHNNE    99999N     20140306E 201403112014030667011M107V 10000000000000        0000000000018000000C  000000755000000 0000001359000 Y0000000002500 0000000000000 0000000000000 0000000000000 0000000000000 0000000000000 0000000000000 0000001361500 NOVX21 INC CL B               0201403060001810                 
  </code></pre>
  
  <p>I'm trying to use something mainstream, e.g. Excel or notepad++ to split each of the 100 rows out to columns, even if it's by inserting a "," at each break so I can open it in excel.</p>
  
  <p>I'm aware I can do this via excel "text to columns" function by dragging the column splitter to the place it's needed but I'm looking for a repeatable process, there are about 10 files of varying widths that come in daily and they could be 10k+ rows at a time but if i could build a macro or script for each of the 10 file types that I can run on demand when I open a fresh file that would be my ultimate goal.</p>