I have a mass of files, all named 1.txt, 2.txt, etc. all the way up to 100.txt in the same directory (let's say C:\Example1) that have come from a website and are either of one of the two following formats:
"blah blah blah, 1234, blahblah" (Always 4 numbers, as it's a year)
or, alternatively:
"blah blah blah, 1234, blah blah"
" , , "
I'd like to convert them to one CSV format, using the commas inside the text files at the moment as the delimiters in the CSV file, with all of the data in the