You can create a custom import filter using Import Wizard where a Python function is used to parse the file and perform the import. For more information on this, please refer to this section on importing files using user-defined functions.