cat _full_list__*.csv | grep ‘”;””;””;””;”‘ | awk -F “;” ‘{ print $1″/”$2 }’ | sed ‘s/\”\/\”/\//g’ | sed -e ‘s/\(.*\)/md5sum \1 \>\> _md5sums\.list /g’ > do_md5sums_x
after executing the do_mdtsums_x (chmod +x do_md5sums_x)
and
sed -e ‘s/ \./”;”./g’ -e ‘s/\(.*\)/”\1″/g’ -e ‘s/\(.*\)\/\(.*[^\/].*\)/\1″;”\2/g’ < _md5sums.list > _md5sums_imp.list
i can now import the list into mysql.