awk to search for specific line and replace nth column Post: 302878908

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

search pattern and replace x-y characters in nth line after every match

Hi, I am looking for any script which can do the following. have to read a pattern from fileA and copy it to fileB. fileA: ... ... Header ... ... ..p1 ... ... fileB: .... .... Header

2. Shell Programming and Scripting

Replace specific field on specific line sed or awk

I'm trying to update a text file via sed/awk, after a lot of searching I still can't find a code snippet that I can get to work. Brief overview: I have user input a line to a variable, I then find a specific value in this line 10th field in this case. After asking for new input and doing some...

3. Shell Programming and Scripting

Using AWK to find top Nth values in Nth column

I have an awk script to find the maximum value of the 2nd column of a 2 column datafile, but I need to find the top 5 maximum values of the 2nd column. Here is the script that works for the maximum value. awk 'BEGIN { subjectmax=$1 ; max=0} $2 >= max {subjectmax=$1 ; max=$2} END {print...

4. Shell Programming and Scripting

Calculating average for every Nth line in the Nth column

Is there an awk script that can easily perform the following operation? I have a data file that is in the format of 1944-12,5.6 1945-01,9.8 1945-02,6.7 1945-03,9.3 1945-04,5.9 1945-05,0.7 1945-06,0.0 1945-07,0.0 1945-08,0.0 1945-09,0.0 1945-10,0.2 1945-11,10.5 1945-12,22.3...

5. Shell Programming and Scripting

awk : search last index in specific column

I am trying to search a given text in a file and find its last occurrence index. The task is to append the searched index in the same file but in a separate column. I am able to accomplish the task partially and looking for a solution. Following is the detailed description: names_file.txt ...

6. Shell Programming and Scripting

Search Replace Specific Column using RegEx

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

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

9. Shell Programming and Scripting

Search term in nth field and replace kth column

Hi, I have a text file which looks like this a.txt 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...

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}

LEARN ABOUT PHP

str_ireplace

STR_IREPLACE(3) 							 1							   STR_IREPLACE(3)

str_ireplace - Case-insensitive version ofstr_replace(3).

SYNOPSIS

       mixed str_ireplace (mixed  $search, mixed  $replace, mixed  $subject, [int  &$count])

DESCRIPTION

	This  function	returns  a string or an array with all occurrences of $search in $subject (ignoring case) replaced with the given $replace
       value. If you don't need fancy replacing rules, you should generally use this function instead of preg_replace(3) with the i modifier.

PARAMETERS

	If $search and $replace are arrays, then str_ireplace(3) takes a value from each array and uses them to search and replace on $subject. If
       $replace  has  fewer  values  than  $search,  then  an  empty string is used for the rest of replacement values. If $search is an array and
       $replace is a string, then this replacement string is used for every value of $search. The converse would not make sense, though.

	If $search or $replace are arrays, their elements are processed first to last.

	      o $search
		- The value being searched for, otherwise known as the needle. An array may be used to designate multiple needles.

	      o $replace
		- The replacement value that replaces found $search values. An array may be used to designate multiple replacements.

	      o $subject
		- The string or array being searched and replaced on, otherwise known as the haystack.	If $subject is an array, then  the  search
		and replace is performed with every entry of $subject, and the return value is an array as well.

	      o $count
		- If passed, this will be set to the number of replacements performed.

RETURN VALUES

	Returns a string or an array of replacements.

EXAMPLES

       Example #1

	      str_ireplace(3) example

	      <?php
	      $bodytag = str_ireplace("%body%", "black", "<body text=%BODY%>");
	      ?>

NOTES

       Note

	      This function is binary-safe.

       Caution

	      Replacement order gotcha

	       Because	str_ireplace(3)  replaces  left  to  right, it might replace a previously inserted value when doing multiple replacements.
	      Example #2 in the str_replace(3) documentation demonstrates how this may affect you in practice.

SEE ALSO

       str_replace(3), preg_replace(3), strtr(3).

PHP Documentation Group 													   STR_IREPLACE(3)