The block quote below is a sample of my data stored in a .txt file. Simply, I can import my expected data if it only has headers and data values, but in this case, there are some redundant information which I should remove to make a data set. Please help to generate a set of code that I can import this data from txt file and make a data set including only ID,Name,Department,DOB and corresponding data values. Other information such as "Date: 20180128" , "THIS IS THE TITLE" , "Page 1" should be removed. Hope for the support with appreciation. Date:20180128 Page 1 THIS IS THE TITLE ID Name Department DOB 1 John Math 1980/01/30 2 Peter Physics 1985/02/15 Date:20180128 Page 2 THIS IS THE TITLE ID Name Department DOB 3 Pop Math 1982/05/30 4 Mary IT 1985/07/15 Date:20180128 Page 3 THIS IS THE TITLE ID Name Department DOB 5 Kata Math 1982/05/30 6 Tom IT 1985/07/15
... View more