10-12-2012
Its still not working :
$ ./movefiles.sh
mkdir: cannot create 10112012_073952.xls
10112012_073952.xls: File exists
mv: 10112012_073952.xls.xls and 10112012_073952.xls are identical.
Just small question , the code given by you has :
#!/bin/ksh typeset -R4 yy for i in *.xls do echo $i | read m d y y=${y##* } y=${y%%_*} yy=$y dir=$d$m$yy [[ -d $dir ]] || mkdir $dir mv -f "$i" $dir done
echo $i | read m d y y=${y##* } ----------------> I think it should be m y=${y%%_*} ----------------> it should be d yy=$y
Let me know your comments.
Moderator's Comments:
|
|
Please use code tags next time for your code and data.
|
|
Last edited by vbe; 10-15-2012 at 12:17 PM..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Howdy,
I'm trying to figure out how to move multiple files based on their creation date. If anyone can enlighten me it would be most appreciated!!
Thanks!
:D (1 Reply)
Discussion started by: dgoyea
1 Replies
2. Shell Programming and Scripting
I have a UNIX box where in files are created every 5 minutes. I need to write a shell script which will take in the date as parameter and return me all files created on that day. Also I will like it to show me only files which have a size greater than 0 i.e. non-empty files. how do I go abt this? I... (6 Replies)
Discussion started by: krahuliyer
6 Replies
3. Shell Programming and Scripting
I need to build a k shell script that will sort files in a directory where files appear like this "XXXX_2008021213.DAT. I need to sort by date in the filename and then move files by individual date to a working folder. concatenate the files in the working folder then start a process once... (2 Replies)
Discussion started by: rebel64
2 Replies
4. Shell Programming and Scripting
Please Close thread-
Thank You. (1 Reply)
Discussion started by: ezmethod
1 Replies
5. UNIX for Dummies Questions & Answers
Hi,
How can I move directories (and all sub directories/files) from one directory to another based on the modified date of the directory?
Currently the existing structure looks like this:
/public_html/media/videos/tmb/34947/image1.jpg
/public_html/media/videos/tmb/34947/image2.jpg
... (0 Replies)
Discussion started by: lbargers
0 Replies
6. Shell Programming and Scripting
Hello,
I'm trying to move the log files from the parent directory to respective monthly folder and I would be running this script on a weekly basis through cron.
I'm new to this scripting and here is what i could come up and it runs without really doing anything. I even tried placing echo... (2 Replies)
Discussion started by: jusblues
2 Replies
7. UNIX for Dummies Questions & Answers
hi
i have to move files and send an email and attached the bad files to inform the developer about that.
#!/bin/ksh
BASE_DIR=/data/SrcFiles
cd $BASE_DIR
## finding the files from work directory which are changed in 1 day
find -type f -name "*.csv" –ctime 0 > /home/mydir/flist.txt
##... (14 Replies)
Discussion started by: awais290
14 Replies
8. Shell Programming and Scripting
Hi All,
I am currently coding for a requirement(LINUX OS) where I am supposed to move a file (Lets Call it Employee.txt) from Directory A to Directory B based on 2 date fields as below,
Date_Current = 20120620
Date_Previous = 20120610
Source Directory : /iis_data/source
Target... (11 Replies)
Discussion started by: dsfreddie
11 Replies
9. Shell Programming and Scripting
Hi All,
I have multiple files in the folder, I want to move those files into the other folder on based of name
File names:
Template_server1_01==>
Template_server1_02==>To one directory /Server1
Template_server1_03==>
Template_server2_01==>
Template_server2_02==>To one... (9 Replies)
Discussion started by: sharsour
9 Replies
10. Shell Programming and Scripting
Hi all
I am trying to loop through a directory of files using a given search pattern. some of the files will be duplicated due to the pattern, but of the duplicate files i wanted to move the older files to another location.
Is there any straightforward way of doing this ?
One of ways I... (1 Reply)
Discussion started by: sthapa
1 Replies
LEARN ABOUT DEBIAN
runxlrd
RUNXLRD(1) General Commands Manual RUNXLRD(1)
NAME
runxlrd - extract data from Microsoft Excel spreadsheet files
SYNOPSIS
runxlrd [options] command [input-file-patterns]
DESCRIPTION
This manual page documents briefly the runxlrd command.
runxlrd offers a commandline interface to the Python xlrd module; it extracts data from Microsoft Excel spreadsheet files.
OPTIONS
-h, --help
Show summary of options and exit.
-l logfilename
Contains error messages.
-v verbosity, --verbosity=verbosity
Level of information and diagnostics provided.
-p pickleable, --pickleable=pickleable
1: ensure Book object is pickleable (default); 0: don't bother.
-m mmap, --mmap=mmap
1: use mmap; 0: don't use mmap; -1: accept heuristic.
-e encoding, --encoding=encoding
Encoding override.
-f formatting, --formatting=formatting
0 (default): no fmt info 1: fmt info (all cells) 2: fmt info (margins trimmed).
-g gc, --gc=gc
0: auto gc enabled; 1: auto gc disabled, manual collect after each file; 2: no gc.
-s onesheet, --onesheet=onesheet
Restrict output to this sheet (name or index).
COMMANDS
Valid commands are
o dump
o count_records
o version
o hdr
o ov
o show
o 2rows
o 3rows
o bench
o names
o name_dump
o labels
o xfc
o hotshot
o profile
See the xlrd API documentation for the meaning of these commands.
EXAMPLES
To show the first, second and last rows of each sheet in each file, run
$ runxlrd 3rows *blah*.xls
Run
$ runxlrd -e koi8_r 3rows myfile.xls
to explicitly pass the needed codepage to xlrd, e.g. if the codepage record is missing, or if it exists but is wrong.
SEE ALSO
The xlrd API documentation, shipped in the file xlrd.html.
The xlrd website <http://www.lexicon.net/sjmachin/xlrd.htm>.
AUTHOR
runxlrd was written by John Machin.
This manual page was written by Joost van Baal <joostvb+debian@uvt.nl>, for the Debian project (but may be used by others).
xlrd 0.6.1a4 2007-05-24 RUNXLRD(1)