Help parsing filename with bash script

mtehonica · January 12, 2011, 9:46am

Hi all!

Looking for some help parsing filenames in bash. I have a directory full of files named "livingroom-110111105637.avi". The format is always date and time (yymmddhhmmss). I'm looking to parse the filenames so they are a little more easily readable. Maybe rename them to "livingroom-110111-10.56.37" or maybe "livingroom-2011.Jan.11-10.56.37". Any advice would be great!!

Thanks in advance!

zaxxon · January 12, 2011, 10:01am

Example with GNU awk on Linux:

$> echo livingroom-110111105637.avi| awk -F[-.] '{d=substr($2,0,6); h=substr($2,7,2); m=substr($2,9,2);s=substr($2,11,2); print $1"-"d"-"h"."m"."s"."$3}'
livingroom-110111-10.56.37.avi

If "-" is not always the delimeter between name and date/time, you might want to modify this to your needs.

mtehonica · January 12, 2011, 10:08am

zaxxon:

Example with GNU awk on Linux:
$> echo livingroom-110111105637.avi| awk -F"[-.]" '{d=substr($2,0,6); h=substr($2,6,2); m=substr($2,8,2);s=substr($2,10,2); print $1"-"d"-"h"."m"."s"."$3}'
livingroom-110111-11.05.63.avi
If "-" is not always the delimeter between name and date/time, you might want to modify this to your needs.

Amazing! Thank you very much! Looks like it's off by 1 position though, the 7 at the end is cut off, the output for that example should be "livingroom-110111-10.56.37.avi"

JavaHater · January 12, 2011, 10:24am

 echo livingroom-110111105637.avi | sed -r 's@(.*-......)(..)(..)(..)@\1-\2.\3.\4@'

mtehonica · January 12, 2011, 10:29am

Wow, you guys are quick! Thanks again!