I have a text file that I need converted into a CSV using Python.
The format currently is this:
http://string/variable/-firstname-lastname/variable
http://string/variable/-firstname-lastname/variable
http://string/variable/-firstname-lastname/variable
Any line that does not parse properly should simply be dumped.
The "/"'s are always as described with a / before and after the firstname lastname combination.
The first "http://string/variable/" is the same depending on what I'm doing, so it needs to be configurable in the script.
I need the Firstname and Lastname separated out as one field and without any dashes (convert dashes to spaces unless preceding a name or trailing).
I would also need the entire link assigned a field.
It would also have to parse the source file into a series of 2MB files (Preferably configurable in the script)
Make sense? Thanks.