Shell Programming and Scripting

hi,

i have various csv files, the file format is as follows


Entry: "1",4,2010/08/15-10-00-00.01,,"E",,,,,,,,,120,0,"M4_","C","KEW-011-5337140-20100916163456-540097","1234567890","N N 0 ",,,"NUK 800100200",,,"NN",,,,,,,,,,,,"0000000001|0001|20150401 10203001|001","6151|886|9024|N|N|N|0033


in this i want to change the 3rd field(2010/08/15-10-00-00.01) if the user enters a particular date it must change to that in all records...

Eg:
if he enters 201209 all records in all files must have the year and month of the 3rd field changed (2012/09/15-10-00-00.01)..can anyone tell me how to do it??


should i use perl or awk or anything.....

Try this,

Code:

#!/usr/bin/perl

use strict;

print "Enter year month:-";
my $YR_MON=<STDIN>;

my $YR=substr($YR_MON,0,4);
my $MON=substr($YR_MON,4);
chomp($YR,$MON);

open (FH,"<","/path/file") || die "Cannot open file\n";

while (<FH>) {
s/(.+?),(.+?),(\d+\/)(\d+\/)/$1,$2,$YR\/$MON\//;
print $_;
}
close(FH);

Invocation

Code:

perl scriptname.pl

This is could help..maybe..

Code:

d=$(date "+%Y%m")|awk -F, -v dt=$d '{gsub($3,dt)}1' inputfile