Do you mean something like: #!/bin/sh FILENAME=`basename $1 .pdf` set -- `echo $FILENAME | sed -e 's/_/ /g'` p1=$1 p2=$2 p3=$3 p4=$4 p5=$5 # Following assumes the testtable table has already be created in # mysql's test database. echo "insert into testtable set p1='$p1',p2='$p2',p3='$p3',p4='$p4',p5='$p5'" | mysql -u test -p \ test test mkdir -p /customers/$p1 mv $FILENAME /customers/$p1/${p2}_${p3}_${p4}_${p5}
--Bruce On Sun, 2003-11-23 at 22:19, Vince McHugh wrote: > Hi All, > > I'd like to preface this question by saying I don't > know much about databases. But I am trying to work > with a customer who is trying to do the following... > > I am supplying them with scanning equipment that can > produce a pdf file with "meta data" in the file name. > It will look something like this: > > info1_info2_info3_info4_info5.pdf > > The info1 - info5 will be replaced by specific meta > data with information about the PDF file. > > Now the question, We would like to know if there is > a way to write a script that would strip out the info > fields separated by underscores (this separator could > be changed to any valid character) and populate > database fields, possibly using MySQL. > > The second thing that we would like the script to do > is to move the file from one folder to another > possibly based one one of the info fields name. For > instance if the info1 field is a customers name or > number that the file would be moved to a folder with > that name. > > I hope that this is OK to ask here, if not I would > appreciate pointing me in the right direction. Thanks > for any feedback. > > ===== > . Regards, > Vince McHugh > Systems Support Manager > NECS\Canon > > __________________________________ > Do you Yahoo!? > Free Pop-Up Blocker - Get it now > http://companion.yahoo.com/ > _______________________________________________ > gnhlug-discuss mailing list > [EMAIL PROTECTED] > http://mail.gnhlug.org/mailman/listinfo/gnhlug-discuss
signature.asc
Description: This is a digitally signed message part