Suppose now I have the following string as below:
'DATA B - 22Aug18\nName Occupation Address Marry Teacher Cali Hobby listen music Sex F Sport swim Jack Doctor Texas Hobby Read book Sex M Sport Badminton \nDATA B - 22Aug18 \nName Occupation Address John student Cali Hobby Game Sex F Sport Tennis Susan freelancer NY Hobby Read book Sex M Sport Running'
And I need to get the following result:
Name Occupation Address Hobby Sex Sport
Mary teacher Cali listen music F swim
Jack Doctor Texas Read book M Badminton
John student Cali Game F Game
Susan freelancer NY Read book M Tennis
I can not how to describe this transformation. Anyone can help me? Thank you
'DATA B - 22Aug18\nName Occupation Address Marry Teacher Cali Hobby listen music Sex F Sport swim Jack Doctor Texas Hobby Read book Sex M Sport Badminton \nDATA B - 22Aug18 \nName Occupation Address John student Cali Hobby Game Sex F Sport Tennis Susan freelancer NY Hobby Read book Sex M Sport Running'
And I need to get the following result:
Name Occupation Address Hobby Sex Sport
Mary teacher Cali listen music F swim
Jack Doctor Texas Read book M Badminton
John student Cali Game F Game
Susan freelancer NY Read book M Tennis
I can not how to describe this transformation. Anyone can help me? Thank you