Data Cleaning

There are 219 text files which are in a merged format (there are around 5-150 individual text docs within the large file). Each new doc has a clear delimiter (something like file 15 of 83 will be written inside the document). The documents themselves are not very large (less than 1 MB) and the amount of text within each file is also not large (see example attached).

I need a) each text file to be separated and and labeled by its NASDAQ Ticker (the information of which is already there in the file, or if not in some cases, can be easily obtained via Google). I also have a master file for the Ticker b) The label of the file should also contain the date of the doc (each separate doc is an announcement and the date can be obtained easily). So ultimately each file should be named wxyzMMYYY where wxyz is the relevant ticker.

The files then need to be stored in a cloud and shared.

The example files include two merged files and one separated doc. I have already separated 50 of them so the rest need to be done (i.e. 169 left). I have no clue whether this can be automated but doing this manually should be easy enough as well. Need the final data in about a week.

I'll also respond to messages after the next 12 hours (it's pretty late in my timezone).