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

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to replace all occurences of a search string using sed

All, Here is what I am searching for using sed. 1 00640000106798 I want to replace that with the following. 8 0064B0000106798 I can do this easy enough from the command line using sed but I need to put the search string in a file and then execute the sed command within a...

2. UNIX for Dummies Questions & Answers

How to search and replace a particular line in file with sed command

Hello, I have a file and in that, I want to search for a aprticular word and then replace another word in the same line with something else. Example: In file abc.txt, there is a line <host oa_var="s_hostname">test</host> I want to search with s_hostname text and then replace test with...

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

4. Shell Programming and Scripting

awk/sed string search and replace

Need help with either sed or awk to acheive the following file1 ----- In the amazon forest The bats eat all the time... mon tue wed they would eat berries In the tropical forest The bats eat all the time... on wed bats eat nuts In the rain forest The bats eat all the time... on...

5. Shell Programming and Scripting

How to use SED or AWK to search and replace an exact string

I have a file DS1 DDS DS I want to replace only "DS" to "DSmail.blah.com" in a lot of files. I tried sed 's/DS/DSmail.blah.com' but it changes all the lines . thanks in advance

6. Shell Programming and Scripting

awk/sed to search & replace data in first column

Hi All, I need help in manipulating the data in first column in a file. The sample data looks like below, Mon Jul 18 00:32:52 EDT 2011,NULL,UAT Jul 19 2011,NULL,UAT 1] All field in the file are separated by "," 2] File is having weekly data extracted from database 3] For eg....

7. Shell Programming and Scripting

sed or awk command to replace a string pattern with another string based on position of this string

here is what i want to achieve... consider a file contains below contents. the file size is large about 60mb cat dump.sql INSERT INTO `table1` (`id`, `action`, `date`, `descrip`, `lastModified`) VALUES (1,'Change','2011-05-05 00:00:00','Account Updated','2012-02-10...

8. Shell Programming and Scripting

Help with Passing the Output of grep to sed command - to find and replace a string in a file.

I have a file example.txt as follows :SomeTextGoesHere $$TODAY_DT=20140818 $$TODAY_DT=20140818 $$TODAY_DT=20140818I need to automatically update the date (20140818) in the above file, by getting the new date as argument, using a shell script. (It would even be better if I could pass...

9. Shell Programming and Scripting

sed - search and replace whole string which contains dot

Hello. I would like to search exactly "string1.string2.string3" and replace it by "new_string1.new_string2.new_string3" And I would like to search exactly "string2.string3" and replace it by "new_string2.new_string3" And I would not found in the result : "string1.new_string2.new_string3"...

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

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. Shell Programming and Scripting

Need to replace all occurences of a search string using sed

Discussion started by: mjs3221

2. UNIX for Dummies Questions & Answers

How to search and replace a particular line in file with sed command

Discussion started by: sshah1001

3. UNIX for Dummies Questions & Answers

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

Discussion started by: ksailesh

4. Shell Programming and Scripting

awk/sed string search and replace

Discussion started by: jville