I want to import some log files from the past years to a single table. There are 100+ files per directory with the date of the log included in the name, for example: app_07122009.log I would like to import every single items in all the files both inside and outside the directories with the name as year into a single table.
On top of this I have to add a column which will show the log date of the item, i.e. truncate the date from the log file name and add a column to all the rows for every logs.
What can I do with this? Thanks a lot!