Replace if regex on specific column matches expression? Post: 302261729

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to replace a specific word in specific column?

Hi My orginal file is like (100s of lines) id host ip location remarks 1 host1 ip1 - xxx 2 host2 ip2 - xxx 3 host3 ip3 - xxx -- -- 9 host9 ip9 - xxx I have a ref file like host1 location1 host2 location2 host3 location3 -- --...

2. Shell Programming and Scripting

replace a column in a file if it matches certain pattern

Hi, I want to replace a column in a file if it matches certain pattern. Can you help me on this. Here is the file content. 000000 1111111 2222222 011111 0123445 1234556 023445 1111111 2343455 if second column contains 1111111 i need to replace it with 0000000 Can you...

3. Shell Programming and Scripting

SED Replacing all but one regex match on a line or specific matches

Hi, I'm attempting to rename some files that have spaces in them. Without linking sed commands together is it possible to replace the first three "." to " ". File.name.is.long.ext -> File name is long.ext I can get the desired effect with echo "File.name.is.long.ext" | sed 's/\./ /g;s/...

4. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Can anyone please help with this? I have 2 files as given below. If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value. file1 abc_1 foo1@a .... abc_1 soo2@a ... def_2 soo2@a .... def_2 foo1@a ........

5. Shell Programming and Scripting

Bash Replace value in specific column

Hi all, I have two files with the following format: file1 BBB;33 AAA;2 CCC;5 file2 5;.;.;. 33;.;.;. The first file contain a list of code and numbers. The second file only the number. I would like to replace the corresponding code in the first column of the file1 with the...

6. Shell Programming and Scripting

Help with replace specific column command

Input file: ASD_QAW 12 A_@ AE_AQ 21 PA_123 ASDA_@ 23 ADA_AS . . Output file: ASD_QAW 12 A @ AE_AQ 21 PA 123 ASDA_@ 23 ADA AS . . Do anybody know how to just specific and replace "_" in column 3 with tab delimiter (\t)? Thanks for advice.

7. Shell Programming and Scripting

Replace a specific column with a specific value

Hi, I am looking to replacing value of a specific column of /etc/pam.d/system-auth file. My file looks like this password sufficient pam_unix.so md5 shadow nullok try_first_pass use_authtok expected result password sufficient pam_unix.so md5 shadow nullok try_first_pass use_authtok...

8. Shell Programming and Scripting

CSV file REPLACE COLUMN if it matches

I have a file cat 1.txt AAAA , BBBB , CCCC , DDDD DFDF , DFDF , DFDF , FDDD AA11 , DFDF , 0000 , UTIO ADSD , WERT, 0000 , JKJL If the 3rd column is not equal to "0000" , then it should replace "0000" with "XXXX" and if its equal to "0000" then print the line as it is. need help.

9. Shell Programming and Scripting

Search Replace Specific Column using RegEx

10. UNIX for Beginners Questions & Answers

Regex Expression Replace

I have a XML file where there is a tag with like <wd:address_line_1>1234 Street</wd:address_line_1> I want to replace the values "1234 Street" with "Test Data". Different people have different address lines and i want to replace with a fixed value to mask the file. I was trying to use sed...

LEARN ABOUT DEBIAN

www::search::washpost

WWW::Search::WashPost(3pm)				User Contributed Perl Documentation				WWW::Search::WashPost(3pm)

NAME

       WWW::Search::WashPost - WWW::Search backend for searching www.washingtonpost.com

SYNOPSIS

	 use WWW::Search;
	 my $oSearch = new WWW::Search('WashPost');
	 my $sQuery = WWW::Search::escape_query("japan prime minister");
	 $oSearch->native_query($sQuery);
	 while (my $oResult = $oSearch->next_result())
	   { print $oResult->url, "
"; }

DESCRIPTION

       This class is a specialization of WWW::Search.  It handles making and interpreting searches on news at The Washington Post
       http://www.washingtonpost.com.

       This class exports no public interface; all interaction should be done through WWW::Search objects.

NOTES

       In the resulting WWW::SearchResult objects, the following elements will be set (in addition to the usual title, description, etc.):

       source
	   Something like "Post" or a certain "Edition".

       location
	   The page number of the print edition, e.g. "E05".

       category
	   The type of item found, either "Article" or "Photo".

       seller
	   The author or photographer.

SEE ALSO

       To make new backends, see WWW::Search.

CAVEATS

       This backend (and all its subclasses) only searches news stories from the last 14 days.	(This is a restriction on the Washington Post
       website that we can not avoid.)

BUGS

       Please tell the author if you find any!

AUTHOR

       Martin Thurn <mthurn@cpan.org>

LICENSE

       Copyright (C) 1998-2009 Martin 'Kingpin' Thurn

       This software is released under the same license as Perl itself.

perl v5.12.4							    2011-11-02						WWW::Search::WashPost(3pm)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to replace a specific word in specific column?

Discussion started by: ./hari.sh

2. Shell Programming and Scripting

replace a column in a file if it matches certain pattern

Discussion started by: Krrishv

3. Shell Programming and Scripting

SED Replacing all but one regex match on a line or specific matches

Discussion started by: vectox

4. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Discussion started by: prashali