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

$ echo Filename_Name_2012013001010101.txt | awk '/^[0-9]/{print substr($1,1,8)}' RS='[_.]'
20120130

Create a file with list of file names to be loaded, use SQL loader to load them to Oracle DB.

Verify the result of load operation, if successful then run below bash script to perform the move:

#!/bin/bash
while read filename
do
        fname=${filename##*_}
        dir=${fname:0:8}
        echo mkdir -p "$dir"
        echo mv "$filename" "${dir}/"
done < file.list

Thanks for you reply,

But forgot to tell you that Filename may have numbers as well apart from Date and Full file name will have n. number of underscores. What i need is we should pick up the date from end of the file name as it has date and time before the extension of file.

If you want to extract the date from end of the file name, then try this:

filename="Filename_Name_2012013001010101.txt"
fname=${filename%%.*}
fname=${fname##*_}
dir=${fname:0:8}

Thanks Bipin,

I tried running the script using your code but it gives an error saying bad substitution at "dir=${fname:0:8}"

Which shell are you using?

bakunin