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

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_replace

STR_REPLACE(3)								 1							    STR_REPLACE(3)

str_replace - Replace all occurrences of the search string with the replacement string

SYNOPSIS

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

DESCRIPTION

	This function returns a string or an array with all occurrences of $search in $subject replaced with the given $replace value.

	If you don't need fancy replacing rules (like regular expressions), you should always use this function instead of preg_replace(3).

PARAMETERS

	If  $search and $replace are arrays, then str_replace(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

	This function returns a string or an array with the replaced values.

EXAMPLES

       Example #1

	      Basic str_replace(3) examples

	      <?php
	      // Provides: <body text='black'>
	      $bodytag = str_replace("%body%", "black", "<body text='%body%'>");

	      // Provides: Hll Wrld f PHP
	      $vowels = array("a", "e", "i", "o", "u", "A", "E", "I", "O", "U");
	      $onlyconsonants = str_replace($vowels, "", "Hello World of PHP");

	      // Provides: You should eat pizza, beer, and ice cream every day
	      $phrase  = "You should eat fruits, vegetables, and fiber every day.";
	      $healthy = array("fruits", "vegetables", "fiber");
	      $yummy   = array("pizza", "beer", "ice cream");

	      $newphrase = str_replace($healthy, $yummy, $phrase);

	      // Provides: 2
	      $str = str_replace("ll", "", "good golly miss molly!", $count);
	      echo $count;
	      ?>

       Example #2

	      Examples of potential str_replace(3) gotchas

	      <?php
	      // Order of replacement
	      $str     = "Line 1
Line 2
Line 3
Line 4
";
	      $order   = array("
", "
", "
");
	      $replace = '<br />';

	      // Processes 
's first so they aren't converted twice.
	      $newstr = str_replace($order, $replace, $str);

	      // Outputs F because A is replaced with B, then B is replaced with C, and so on...
	      // Finally E is replaced with F, because of left to right replacements.
	      $search  = array('A', 'B', 'C', 'D', 'E');
	      $replace = array('B', 'C', 'D', 'E', 'F');
	      $subject = 'A';
	      echo str_replace($search, $replace, $subject);

	      // Outputs: apearpearle pear
	      // For the same reason mentioned above
	      $letters = array('a', 'p');
	      $fruit   = array('apple', 'pear');
	      $text    = 'a p';
	      $output  = str_replace($letters, $fruit, $text);
	      echo $output;
	      ?>

NOTES

       Note

	      This function is binary-safe.

       Caution

	      Replacement order gotcha

	       Because str_replace(3) replaces left to right, it might replace a previously inserted value when doing multiple	replacements.  See
	      also the examples in this document.

       Note

	       This function is case-sensitive. Use str_ireplace(3) for case-insensitive replace.

SEE ALSO

       str_ireplace(3), substr_replace(3), preg_replace(3), strtr(3).

PHP Documentation Group 													    STR_REPLACE(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