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

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Search and replace string only in a particular column in a delimited file

I have file with multiple columns. Column values for a record may be same. Now i have to replace a column value(this can be same for the other columns) with new value. File.txt A,B,C,D,A,B,C,D,A,B,C,D A,B,C,D,A,B,C,D,A,B,C,D A,B,C,D,A,B,C,D,A,B,C,D A,B,C,D,A,B,C,D,A,B,C,D...

2. UNIX for Dummies Questions & Answers

Search a string in the file and then replace another string after that position

Hi I am looking for a particular string in a file.If the string exists, then I want to replace another string with some other text.Once replaced, search for the same text after that character position in the file. :wall: E.g: Actual File content: Hello Name: Nitin Raj Welcome to Unix...

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

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

5. Shell Programming and Scripting

How to search and replace string in column in file with command sed?

how to search and replace string in column in file with command sed or other search "INC0000003.in" and replace column 4 = "W" $ cat file.txt INC0000001.in|20150120|Y|N|N INC0000002.in|20150120|Y|N|N INC0000003.in|20150120|Y|N|N INC0000004.in|20150120|Y|N|Noutput...

6. UNIX for Dummies Questions & Answers

Search for a string,delete the line and replace with new string in a file

Hi Everyone, I have a requirement in ksh where i have a set of files in a directory. I need to search each and every file if a particular string is present in the file, delete that line and replace that line with another string expression in the same file. I am very new to unix. Kindly help...

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

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

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

10. UNIX for Beginners Questions & Answers

Search partial string in a file and replace the string - UNIX

I have the below string which i need to compare with a file and replace this string in the file which matches closely. Can anyone help me on this. string(Scenario 1)- user::r--,user::ourfrd:r-- String(Scenario 2)- user::r-- File **** # file: /local/Desktop/myfile # owner: me # group:...

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)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Search and replace string only in a particular column in a delimited file

Discussion started by: ksailesh

2. UNIX for Dummies Questions & Answers

Search a string in the file and then replace another string after that position

Discussion started by: dashing201

3. Shell Programming and Scripting

Replace the nth column date as MM/DD/YYYY

Discussion started by: anshaa

4. Shell Programming and Scripting

awk to search for specific line and replace nth column

Discussion started by: ncwxpanther