Shell Programming and Scripting

I have csv file where I want the second column has to be replaced with value 1.

Source file
919568760477,1,2011-07-11T22:34:27.000+05:30,
919557735692,2,2011-07-11T22:36:16.000+05:30,
917417384969,2,2011-07-11T22:33:26.000+05:30,

Final file


919568760477,1,2011-07-11T22:34:27.000+05:30,
919557735692,1,2011-07-11T22:36:16.000+05:30,
917417384969,1,2011-07-11T22:33:26.000+05:30,

Kindly let me know the best efficient with sed or awk.

Thanks

Code:

 
$ nawk -F, 'BEGIN{OFS=","}{$2=1;print}' input.txt
919568760477,1,2011-07-11T22:34:27.000+05:30,
919557735692,1,2011-07-11T22:36:16.000+05:30,
917417384969,1,2011-07-11T22:33:26.000+05:30,

Or with Sed..

Code:

sed 's/,./,1/' inputfile

if you have more than one digit in the second column, then try this.

Code:

 
sed 's/,\([0-9]*\),/,1,/' input.txt

Micheal how does the sed select the second field in your above command.

Code:

 
,.  --> find first comma, then followed by any one character 
,1 --> replace with comma 1 (,1)
 
we are not using g (global) here, so it replaces the first occurance

,. means first comma followed by only one character. If it has to four characters then ,.... right?


Here is another file where I want to change the second column to 1010

9788691010,5004,20120120002804,
9705645060,5004,20120120004753,
9014961516,5004,20120120004809,