I need to split a file that has multiple headers as follows:
- Break up the file based on the header. Headers always include the word TITLE
- Write each file to a csv file
- Assign a unique name to each file
- Sometimes before the first "TITLE", the file contains some random text I don't need so that would need to be removed.
Can someone advise?
I'm attaching a dummy file similar to the one I need to split and a screenshot of the desired outputs as reference.
Thanks