replace line in CSV file and rename file connected to that name

wademac · 07-14-2009, 02:01 PM

I have a CSV file with

2100480,,,,,The First File Jun 0309.pdf,
2158030,,,,,Another File Name May 0109.pdf,

etc and more information after but not important

what I would like to do is there is a PDF with this file name as well and I need to replace the "The First File Jun 0309.pdf" with the number id "2100480" in the CSV and than rename the physical file called The First File Jun 0309.pdf to 2100480.pdf

the reference number is the same connected to the same PDF file but they add a date on each file for example I may get some in January

2100480,,,,,The First File Jan 0309.pdf,

and in Febuary get

2100480,,,,,The First File Feb 0909.pdf,

etc..

but in the end I only need one file to over right the last with

2100480.pdf

Tinkster · 07-14-2009, 03:28 PM

The spec is a bit meager, but this may be what you're after:

Code:

awk -F, '{file[$1]=$6}END{for(i in file){printf( "mv \"%s\" \"%s.pdf\"\n",file[i],i)}}' csv_file|bash

Cheers,
Tink

wademac · 07-15-2009, 11:09 AM

Quote:

Originally Posted by Tinkster

The spec is a bit meager, but this may be what you're after:

Code:

awk -F, '{file[$1]=$6}END{for(i in file){printf( "mv \"%s\" \"%s.pdf\"\n",file[i],i)}}' csv_file|bash

Cheers,
Tink

That worked great .. it reads the CSV file and than changed all the physical PDF files to the correct number, but how do I now change the PDF names in the CSV to match those new numbered PDF files?

Tinkster · 07-15-2009, 01:09 PM

Quote:

Originally Posted by wademac

That worked great .. it reads the CSV file and than changed all the physical PDF files to the correct number, but how do I now change the PDF names in the CSV to match those new numbered PDF files?

OK, now I notice/understand the 2nd part of the question :}

Code:

awk 'BEGIN{FS=OFS=","}{file[$1]=$6;$6=sprintf("%s.pdf",$1);print $0>"csv_file.tmp"}END{for(i in file){printf( "mv \"%s\" \"%s.pdf\"\n",file[i],i)};system(" mv csv_file.tmp csv_file " )}' csv_file|bash

Cheers,
Tink