NotePad file creating importing issues

Or GREP will do the trick. 

Like others already mentioned - show us an example.

But - if you have access to WORD / Excel - it would be pretty easy to "fix" the data. 

1a) import your file into WORD - convert into table with space as a delimiter,

1b) import your file into Excel - convert text into columns - space as delimiter,

2) cut first two columns - TAX & YEAR - and paste into new document,

3) cut last three columns - AMOUNT, COST, TOTAL - into same new document - as additional columns,

4) in the new document - insert new column - after 2nd column - between YEAR & AMOUNT,

5) join columns you've left with in the source WORD (1a) / Excel (1b) file and paste it into 3rd column in the new document,

6) either convert into TAB delimited file or copy&paste directly to InDesign.

Or you can do all those steps in the InDesign itself - just import as plain text and convert into raw table and then above steps - creating extra table(s). 

See my next reply - sorry, should have gave it a bit more thought before posting - but still doable. 

Can you share about 10 (redacted or not) lines of this file?

I've done a lot of such conversions from clumsily exported data. Sometimes you can find a "key" that will let you put tabs in the right places, etc.

At that scale, you will save a vast amount of time by going back to the client for ANY original version of the file or a new export using more standard separators. It sounds as if it was exported from Word, Excel or a database by someone who didn't really understand what needed to happen down stream.

Explain to them clearly that you need records and fields clearly separated, and how something like CSV or tab-delimited files should be formatted. I'd ask exactly what they are exporting/retrieving the data from; that might help guide things to a more useful work file.

—