Ok so I have a flat comma file that has 20k lines that I need to manipulate. Each line should represent a unique path to a unique filename comma separated. It is not possible to re-generate or re-export the data so this is my only option that I have to work with. Example it should look like this:
what the file looks like is
The number of files per user varies from 1 to 50 or more but is never zero. I need someway to parse the file and rewrite it in the "what it should look like" format.