title: Update values (find and replace)
body: <p>I need to compare and replace a value in two files.  I have two flat files of approximately 1000+ employee records. The goal is to update the phone number using the employee ID in first column from list UPDATE to RECORD.  I have written something...</p>
  <p><strong>UPDATE RECORDS</strong></p>
  <pre><code>E0000013 8327733241X7131030001
  E0011183 8327731234
  E0000231 8327731873
  E0000453 8321832322
  E0003421 8328722221
  E0000398 8327739741X1112223333
  </code></pre>
  <p><strong>SAMPLE MADEUP RECORD - NOT REAL NAMES OR NUMBERS</strong></p>
  <pre><code>E0000013 MARY JACKSON 1111FANNINS ST HOUSTON TX 77004 7131030001X7131030001 FL21
  E0011187 JANE DOE     1111FANNINS ST HOUSTON TX 77004 7131030003            FL17
  E0000231 JUANITTA     1111FANNINS ST HOUSTON TX 77004 7131030002            FL38
  E0000453 ETHA MACK    1111FANNINS ST HOUSTON TX 77004 7131030004            FL31
  E0000542 EDDIE JOE    1111FANNINS ST HOUSTON TX 77004 7131030009            FL32
  E0003421 FRANCIS Y    1111FANNINS ST HOUSTON TX 77004 7131030008            FL33
  E0000398 ZAYLA YEN    1111FANNINS ST HOUSTON TX 77004 7131030018            FL41
  </code></pre>
  <p><strong>CODE</strong></p>
  <p><em>Please find the updated code in my answer. I am trying to remove a bug that is shifting some of my values.  I am not trying to have anyone write the code for me, but highlight my mistakes and offer good advise.</em></p>
  <h1>EXPECTED OUTCOME</h1>
  <pre><code>E0000013 MARY JACKSON 1111FANNINS ST HOUSTON TX 77004 8327733241X7131030001 FL21
  E0011187 JANE DOE     1111FANNINS ST HOUSTON TX 77004 8327731234            FL17     
  E0000231 JUANITTA     1111FANNINS ST HOUSTON TX 77004 8327731873            FL38
  E0000453 ETHA MACK    1111FANNINS ST HOUSTON TX 77004 8321832322            FL31
  E0000542 EDDIE JOE    1111FANNINS ST HOUSTON TX 77004 8321834343            FL32
  E0003421 FRANCIS Y    1111FANNINS ST HOUSTON TX 77004 8328722221            FL33
  E0000398 ZAYLA YEN    1111FANNINS ST HOUSTON TX 77004 8327739741X1112223333 FL41
  </code></pre>
  <p><strong>ACTUAL-OUTPUT</strong>
  As you may see, the actual output is shifting my data to the right for Mary Jackson and . How can I get rid of the spaces and maintain the floor values from shifting?</p>
  <pre><code>E0000013 MARY JACKSON 1111FANNINS ST HOUSTON TX 77004 8327733241X7131030001            FL21
  E0011187 JANE DOE     1111FANNINS ST HOUSTON TX 77004 7131030003            FL17
  E0000231 JUANITTA     1111FANNINS ST HOUSTON TX 77004 8327731873            FL38
  E0000453 ETHA MACK    1111FANNINS ST HOUSTON TX 77004 8321832322            FL31
  E0000542 EDDIE JOE    1111FANNINS ST HOUSTON TX 77004 8321834343            FL32
  E0003421 FRANCIS Y    1111FANNINS ST HOUSTON TX 77004 8328722221            FL33
  E0000398 ZAYLA YEN    1111FANNINS ST HOUSTON TX 77004 8327739741X1112223333            FL41
  </code></pre>