UNIX for Dummies Questions & Answers

Hi, people.

I need some help with this:

i have this file " PROVEDP_???_yyyymmdd " , and i want to rename to this
" IN_PROV_yyyy???.dat " .

The " ??? " is the Month , but the file could be created on April, but the name coulb be March, for example.So i need to grab the 3 caracters

Because the creation of the file is dynamic only i know is the first 8 caracheters " PROVEDP_ " .

Example:

PROVEDP_JAN_20080205 ( this file was created at 20080205 ) i need to convert to IN_PROV_200801.dat

Could someone help me on this ?

Regards,

osramos

This will do most of it:

Code:

for F in $(\ls -1 PROVEDP_*); do echo $F; mv $F $(echo $F | perl -pe 's/^PROVEDP_(\w{3})_(\d{4}).*$/IN_PROV_$2$1.dat/'); done

It lists all files and then renames them. For example, it will rename PROVEDP_JAN_20080205 to IN_PROV_2008JAN.dat.

However, it doesn't convert JAN to 01, as in your example. You initially said the output needed to contain the "???" you retrieved from the beginning of the file, but then, in your sample output, you showed "01" in the position which would have contained JAN.

So, if that was a typo, then you're done. If you still need it to be converted, then it'll be a little more work but not difficult for you to do.

Notes: The backslash before the ls command forces it to ignore any aliases, so you don't end up trying to process the file's date, owner, etc. The structure is a basic for loop. The section containing the echo and Perl statement within the $() structure returns the output of that section (actually a subshell) to the current command line as a simple string.

ShawnMilo

Code:

awk 'BEGIN {
m["JAN"] = "01"
m["FEB"] = "02"
m["MAR"] = "03"
m["APR"] = "04"
m["MAY"] = "05"
m["JUN"] = "06"
m["JUL"] = "07"
m["AUG"] = "08"
m["SEP"] = "09"
m["OCT"] = "10"
m["NOV"] = "11"
m["DEC"] = "12"
sep = "_"
new = "IN_PROV"
ext = ".dat"
for (i=1; i<ARGC; i++) {
  split(ARGV[i], t, sep)
  print "mv", ARGV[i], new sep substr(t[3],1,4) m[t[2]] ext
   }
}' PROVEDP_*

Use nawk or /usr/xpg4/bin/awk on Solaris.
If you get the correct result, pass the output to the shell via pipe.