title: How to import a text file to sql
body: <p>I have the following text-file with 48.891 names. I would like to import them to a mySQL database. I need the first 3 characters with the gender and the name. The rest should be ignored.</p>
  
  <pre><code>M  Aad                                  4                                             $
  M  Aadam                                          1                                   $
  F  Aadje                                1                                             $
  M  Ådne                      +                 1                                      $
  M  Aadu                                           12                                  $
  ?F Aaf                                  1                                             $
  F  Aafke                                4                                             $
  ?  Aafke                                 1                                            $
  F  Aafkea                                1                                            $
  M  Aafko                                1                                             $
  M  Aage                                       761                                     $
  M  Åge                       +                56                                      $
  F  Aagje                              1 2                                             $
  F  Aagot                                       1                                      $
  F  Ågot                      +                 2                                      $
  F  Aagoth                                      1                                      $
  F  Ågoth                     +                 1                                      $
  M  Åke                       +                118                                     $
  M  Aalbert                              1                                             $
  M  Aalderich                             1                                            $
  M  Aalderk                               1                                            $
  </code></pre>
  
  <p>The database handling isn't my question. The problem is how to filter only the gender and name in the textfile.
  Thnaks for any help in advance.</p>