topic Re: Change filename with awk in Operating System - Linux

Change filename with awk

John Carver — Thu, 08 Oct 2009 20:31:48 GMT

I need to rename a series of files that contain spaces in their names.

Batch(6)_9_25_2009 4-22-25 PM.pdf

I would like to replace the spaces with the underscore character.

Batch(6)_9_25_2009_4-22-25_PM.pdf

Or possibly remove all underscore characters and spaces.

Batch(6)925200942225PM.pdf

I know awk can handle this, but unfortunatly the specific command syntax is a little outside my awk experience.

Re: Change filename with awk

James R. Ferguson — Thu, 08 Oct 2009 21:51:35 GMT

John:

Variously, 'sed' or 'awk' or Perl will do:

# X="Batch(6)_9_25_2009 4-22-25 PM.pdf"

# echo ${X}|sed -e 's/ //g'

# echo ${X}|awk '{gsub(/ /,//,$0);print}'

In the 'awk' snippet, if you wanted to confine your substitution to a particular field then you could use the appropriate field number ( other than $0).

Regards!

...JRF...

Re: Change filename with awk

James R. Ferguson — Thu, 08 Oct 2009 22:04:54 GMT

Hi (again):

Oops; I bungled the 'awk'. Too, you may not want to collapse spaces, but rather to substitute a space with an underscore.

# echo ${X}|sed -e 's/ /_/g'

Awk is a bit odd in the way it defines the arguments to 'gsub'. Use this:

# echo ${X}|awk '{gsub(/ /,"_",$0);print}'

Regards!

...JRF...

Re: Change filename with awk

Steven E. Protter — Thu, 08 Oct 2009 23:28:19 GMT

Shalom,

Perl snippet.

$commandline = "cp ${filetoback} ${filetoback}.bck";
system("${commandline}");
$commandline = "sed s/investmenttool.com/isnamerica.com/g ${filetoback} > $filetoback.bck";
print ("Converting: ${convertiasbackupdir}${filetoback}\n");
print LOGF ("Converting: ${filetoback}\n");
system("${commandline}");
$commandline = "cp ${filetoback}.bck ${filetoback}";
system("${commandline}");

Basically uses the sed to change the contents of a file.

To merely change the name a mv command can do the job.

SEP

Re: Change filename with awk

Goran Koruga — Fri, 09 Oct 2009 04:04:40 GMT

Hello.

Much better to use mmv or prename (might be called something else in your distribution - it's a handy Perl script).

Regards,
Goran

Re: Change filename with awk

Jean-Philippe Henry — Fri, 09 Oct 2009 14:53:08 GMT

Hello,

Almost the same as JRF's but with no assumption on the number of subsequent spaces :

ls *\ * | awk '{ name = $0 ; gsub ( / */, "_" ) ; printf ( "mv \"%s\" %s\n", name, $0 ) }' | ksh

Be careful there are two spaces in / */

Cheers,

Jean-Philippe

Re: Change filename with awk

John Carver — Fri, 09 Oct 2009 17:30:12 GMT

Almost there. I've incorporated sed into a bash script. There might be just one Batch* file or many, thus the need for a loop. mv would be my first choice but fails after trying to change one var to another. I've tried the "line" variable with and without the quotes.

ls Batch* | while read line
do
change=`echo ${line}| sed -e 's/ /_/g'`
mv \"$line\" $change
done

Try `mv --help' for more information.
mv: when moving multiple files, last argument must be a directory
Try `mv --help' for more information.
mv: when moving multiple files, last argument must be a directory
Try `mv --help' for more information.
mv: when moving multiple files, last argument must be a directory

Re: Change filename with awk

Dennis Handly — Sun, 11 Oct 2009 01:34:14 GMT

>I've tried the "line" variable with and without the quotes.
mv \"$line\" $change

Change to actually use quotes: mv "$line" $change

Re: Change filename with awk

John Carver — Mon, 12 Oct 2009 17:25:43 GMT

Thanks for the help. My script can now rename the filenames.