Search Results

Thanks again..I hope this will be my last request on this script..

If the second field has value either 2 or 3, the above script will replace it to 1. I want the script modified to search &...

Super Kamaraj...but only the replace entries are there in the new file..I want both replaced and non-replaced entries in the same file.

Thanks in advance.

Hi Kamaraj,

The script works fine..but as you remember as we redirecting the output back to the source file itself, the other entries which are not replaced are gone. Can you help in modifying the...

hi Kamaraj,

Your script works perfectly. I want one more assistance.

when the awk script it matches second field value and replace the value and I export it to a separate file.

During the...

In my case the the input_file will like *.csv then also will it work?

Works perfectly....bye for now

---------- Post updated at 05:21 PM ---------- Previous update was at 03:48 PM ----------

Hi Kamaraj,

I actually run the awk on multiple files..and export the...

Input file

919925623336,1,2011-07-11T23:33:31.000+05:30,
919099951769,2,2011-07-11T23:34:48.000+05:30,
918306699170,2,2011-07-11T23:32:20.000+05:30,

output File expected
...

Even the awk works, but I want the output to be only the ones which are replaced not all the entries,,Is it possible?

Sorry man I dont have nawk package..Can I use awk instead?

Hi Kamaraj,

In your sed, it replace all the second column value to the replace value, but I want to replace only the one which matches column value not the others.


The sed output has both...

try my suggestion in the #4 post


$ sed 's/,\([0-9]*\),/,1010,/' input.txt
9788691010,1010,20120120002804,
9705645060,1010,20120120004753,
9014961516,1010,20120120004809,



----------...

,. 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
...

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

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,...