Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Search term in nth field and replace kth column
Top Forums Shell Programming and Scripting Search term in nth field and replace kth column Post 302992796 by wahi80 on Wednesday 1st of March 2017 03:39:46 PM
Old 03-01-2017
Search term in nth field and replace kth column
Hi,

I have a text file which looks like this
a.txt
Code:
A,12,Apple,Red
B,33,Banana,Yellow
C,66,Sky,Blue

I need to search for a particular field(s) in particular column(s) and for that matching line need to replace the nth column.
Sample scenario 1:
Search for 66 in second field and Sky in third field, then replace 4th column with Pink.
So now a.txt should look like
Code:
A,12,Apple,Red
B,33,Banana,Yellow
C,66,Sky,Pink

Sample scenario 2:
Search for B in first column and replace 3rd column with Tennis
So now a.txt should look like
Code:
A,12,Apple,Red
B,33,Tennis,Yellow
C,66,Sky,Pink

I'm using grep and sed,writing to tmp files and then overwriting a.txt.
Looking for something simpler, if possible
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Search term and output term in desired field

Hi All, I have an input_file below and i would like to use Perl to search for the term "aaa" and output the 3rd term in the same row as "aaa".For Example, i want to search for the term "ddd" and would want the code to ouput the 3rd term in the same row which is "fff". Can somebody help ? ... (28 Replies)
Discussion started by: Raynon
28 Replies

2. Shell Programming and Scripting

extracting a column using search term

I am trying to select a column using a search term. My input file looks like this (tab delimited): ABC BJS FDG GHH DGH DFG GHF 95 456 5 266 87 4567 67 3 54 678 4567 45 6 36 232 55 3 5 6 8 34 cat filename | awk '{print $2}'above code will give me the second column. However, what I want... (2 Replies)
Discussion started by: SangLad
2 Replies

3. Shell Programming and Scripting

Replace the nth column date as MM/DD/YYYY

Hi, I need some unix command to replace the following thing. cat test.dat 1234|test|8/19/2009|8/20/2009|test 1234|test|8/9/2009|8/21/2009|test 1234|test|8/1/2009|8/2/2009|test after processing 1234|test|08/19/2009|08/20/2009|test 1234|test|08/09/2009|08/21/2009|test... (6 Replies)
Discussion started by: anshaa
6 Replies

4. Shell Programming and Scripting

awk to search for specific line and replace nth column

I need to be able to search for a string in the first column and if that string exists than replace the nth column with "-9.99". AW12000012012 2.38 1.51 3.01 1.66 0.90 0.91 1.22 0.82 0.57 1.67 2.31 3.63 0.00 AW12000012013 1.52 0.90 1.20 1.34 1.21 0.67 ... (14 Replies)
Discussion started by: ncwxpanther
14 Replies

5. Shell Programming and Scripting

Replace a value of Nth field of nth row

Using Awk, how can I achieve the following? I have set of record numbers, for which, I have to replace the nth field with some values, say spaces. Eg: Set of Records : 4,9,10,55,89,etc I have to change the 8th field of all the above set of records to spaces (10 spaces). Its a delimited... (1 Reply)
Discussion started by: deepakwins
1 Replies

6. Shell Programming and Scripting

Replace pattern from nth field from a file

$ cat /cygdrive/d/Final2.txt 1,A ,Completed, 07.03_23.01 ,Jun 30 20:00 2,BBB,Pending,, 3,CCCCC,Pending,, 4,DDDDD,Pending,, 5,E,Pending,, 6,FFFF,Pending,, 7,G,Pending,, In the above file 4th field is date which is in MM.DD_HH.MIN format and I need to convert it to as it is there in 5th... (1 Reply)
Discussion started by: Amit Joshi
1 Replies

7. Shell Programming and Scripting

Replace pattern from nth field from a file

I have posted this again as old post is closed and I am not able to reopen. so please consider this new post Input File : 1,A,Completed,06.02_19.36,Jun 30 20:00 2,BBB,Failed,07.04_05.12,Jul 21 19:06 3,CCCCC,New,07.21_03.03,Jul 26 12:57 4,DDDDD,Pending,, I wast output file as: ... (7 Replies)
Discussion started by: Amit Joshi
7 Replies

8. Shell Programming and Scripting

How to search and replace string from nth column from a file?

I wanted to search for a string and replace it with other string from nth column of a file which is comma seperated which I am able to do with below # For Comma seperated file without quotes awk 'BEGIN{OFS=FS=","}$"'"$ColumnNo"'"=="'"$PPK"'"{$"'"$ColumnNo"'"="'"$NPK"'"}{print}' ${FileName} ... (5 Replies)
Discussion started by: Amit Joshi
5 Replies

9. Shell Programming and Scripting

awk search and replace nth column by using a variable.

I am passing a variable and replace nth value with the variable. I tried using many options in awk command but unable to ignore the special characters in the output and also unable to pass the actual value. Input : "1","2","3" Output : "1","1000","3" TempVal=`echo 1000` Cat... (2 Replies)
Discussion started by: onesuri
2 Replies

10. Shell Programming and Scripting

Replace Value of nth Column of Each Line Using Array

Hello All, I am writing a shell script with following requirement: 1. I have one input file as below CHE01,A,MSC,INO CHE02,B,NST,INC CHE03,C,STM,INP 2. In shell script I have predefined array as below: Array1={A, B, C} Array2= {U09, C04, A054} (6 Replies)
Discussion started by: angshuman
6 Replies

LEARN ABOUT DEBIAN

ansi_cattr

term::ansi::code::attr(3tcl)					 Terminal control				      term::ansi::code::attr(3tcl)

__________________________________________________________________________________________________________________________________________________

NAME

       term::ansi::code::attr - ANSI attribute sequences

SYNOPSIS

       package require Tcl  8.4

       package require term::ansi::code  ?0.1?

       package require term::ansi::code::attr  ?0.1?

       ::term::ansi::code::attr::names

       ::term::ansi::code::attr::import ?ns? ?arg...?

       ::term::ansi::code::attr::fgblack

       ::term::ansi::code::attr::fgred

       ::term::ansi::code::attr::fggreen

       ::term::ansi::code::attr::fgyellow

       ::term::ansi::code::attr::fgblue

       ::term::ansi::code::attr::fgmagenta

       ::term::ansi::code::attr::fgcyan

       ::term::ansi::code::attr::fgwhite

       ::term::ansi::code::attr::fgdefault

       ::term::ansi::code::attr::bgblack

       ::term::ansi::code::attr::bgred

       ::term::ansi::code::attr::bggreen

       ::term::ansi::code::attr::bgyellow

       ::term::ansi::code::attr::bgblue

       ::term::ansi::code::attr::bgmagenta

       ::term::ansi::code::attr::bgcyan

       ::term::ansi::code::attr::bgwhite

       ::term::ansi::code::attr::bgdefault

       ::term::ansi::code::attr::bold

       ::term::ansi::code::attr::dim

       ::term::ansi::code::attr::italic

       ::term::ansi::code::attr::underline

       ::term::ansi::code::attr::blink

       ::term::ansi::code::attr::revers

       ::term::ansi::code::attr::hidden

       ::term::ansi::code::attr::strike

       ::term::ansi::code::attr::nobold

       ::term::ansi::code::attr::noitalic

       ::term::ansi::code::attr::nounderline

       ::term::ansi::code::attr::noblink

       ::term::ansi::code::attr::norevers

       ::term::ansi::code::attr::nohidden

       ::term::ansi::code::attr::nostrike

       ::term::ansi::code::attr::reset

_________________________________________________________________

DESCRIPTION

       This package provides symbolic names for the ANSI attribute control codes. For each control code a single command is provided which returns
       this code as its result. None of the commands of this package write  to	a  channel;  that  is  handled	by  higher  level  packages,  like
       term::ansi::send.

API

   INTROSPECTION
       ::term::ansi::code::attr::names
	      This command is for introspection. It returns as its result a list containing the names of all attribute commands.

       ::term::ansi::code::attr::import ?ns? ?arg...?
	      This  command imports some or all attribute commands into the namespace ns. This is by default the namespace attr. Note that this is
	      relative namespace name, placing the imported command into a child of the current namespace. By default all commands  are  imported,
	      this can howver be restricted by listing the names of the wanted commands after the namespace argument.

   ATTRIBUTES
       ::term::ansi::code::attr::fgblack
	      Set text color to Black.

       ::term::ansi::code::attr::fgred
	      Set text color to Red.

       ::term::ansi::code::attr::fggreen
	      Set text color to Green.

       ::term::ansi::code::attr::fgyellow
	      Set text color to Yellow.

       ::term::ansi::code::attr::fgblue
	      Set text color to Blue.

       ::term::ansi::code::attr::fgmagenta
	      Set text color to Magenta.

       ::term::ansi::code::attr::fgcyan
	      Set text color to Cyan.

       ::term::ansi::code::attr::fgwhite
	      Set text color to White.

       ::term::ansi::code::attr::fgdefault
	      Set default text color (Black).

       ::term::ansi::code::attr::bgblack
	      Set background to Black.

       ::term::ansi::code::attr::bgred
	      Set background to Red.

       ::term::ansi::code::attr::bggreen
	      Set background to Green.

       ::term::ansi::code::attr::bgyellow
	      Set background to Yellow.

       ::term::ansi::code::attr::bgblue
	      Set background to Blue.

       ::term::ansi::code::attr::bgmagenta
	      Set background to Magenta.

       ::term::ansi::code::attr::bgcyan
	      Set background to Cyan.

       ::term::ansi::code::attr::bgwhite
	      Set background to White.

       ::term::ansi::code::attr::bgdefault
	      Set default background (Transparent).

       ::term::ansi::code::attr::bold
	      Bold on.

       ::term::ansi::code::attr::dim
	      Dim on.

       ::term::ansi::code::attr::italic
	      Italics on.

       ::term::ansi::code::attr::underline
	      Underscore on.

       ::term::ansi::code::attr::blink
	      Blink on.

       ::term::ansi::code::attr::revers
	      Reverse on.

       ::term::ansi::code::attr::hidden
	      Hidden on.

       ::term::ansi::code::attr::strike
	      Strike-through on.

       ::term::ansi::code::attr::nobold
	      Bold off.

       ::term::ansi::code::attr::noitalic
	      Italics off.

       ::term::ansi::code::attr::nounderline
	      Underscore off.

       ::term::ansi::code::attr::noblink
	      Blink off.

       ::term::ansi::code::attr::norevers
	      Reverse off.

       ::term::ansi::code::attr::nohidden
	      Hidden off.

       ::term::ansi::code::attr::nostrike
	      Strike-through off.

       ::term::ansi::code::attr::reset
	      Reset all attributes to their default values.

BUGS, IDEAS, FEEDBACK
       This  document, and the package it describes, will undoubtedly contain bugs and other problems.	Please report such in the category term of
       the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883].  Please also report any ideas for enhancements you  may  have  for
       either package and/or documentation.

KEYWORDS

       ansi, attribute control, color control, control, terminal

CATEGORY

       Terminal control

COPYRIGHT

       Copyright (c) 2006 Andreas Kupries <andreas_kupries@users.sourceforge.net>

term									0.1					      term::ansi::code::attr(3tcl)
All times are GMT -4. The time now is 02:48 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy