Hello,

I have a .txt file with lots of data I have saved over time, what is the best (free) software that will allow me to get it into a .csv file for inserting into a database.

The 'records' in the text file are all separated by a string of identifiable characters, so I will know when a new one starts. First part of the 'record' will have a bunch of short fields delimited by '/'s, but after the nth '/', it would be a long stretch of description until the next 'record' starts.

Will python work? How about Windows PowerShell.

Input from text file, output to csv file? Is the csv format the best of output? Will be using MS-Access for database

Thanks