Substring from the file name

view story

http://www.unix.com – Hi I need substring from the file name of list of files. I mean i will have to load all the files into database which are there in the Directory. I need to make the directory with the date(which is substring of the filename Eg: Filename_Name_2012013001010101.txt, So the directory should be 20120130). I need to load this file into oracle and need to move the file into above created directory. It should happend till all files are loaded into database. Could someone give the ideas? Thanks (HowTos)