sed/awk help to match list of patterns and remove from org file Post: 302265366

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing file lines that each match to a different patterns

I have a very large file (10,000,000 lines), that contains a sample id and a property of that sample. I have another file that contains around 1,000,000 lines with sample ids that I want to remove from the original file (create a new file without these lines). I know how to do this in Perl, but it...

2. Shell Programming and Scripting

Using AWK to match CSV files with duplicate patterns

Dear awk users, I am trying to use awk to match records across two moderately large CSV files. File1 is a pattern file with 173,200 lines, many of which are repeated. The order in which these lines are displayed is important, and I would like to preserve it. File2 is a data file with 456,000...

3. Shell Programming and Scripting

Retrieve lines that match any occurence in a list of patterns

I have two files. The first containing a header and six columns of data. Example file 1: Number SNP ID dbSNP RS ID Chromosome Result_Call Physical Position 787066 SNP_A-8575395 RS6650104 1 NOCALL 564477 786872 SNP_A-8575125 RS10458597 1 AA ...

4. Shell Programming and Scripting

Awk-sed help : to remove first and last line with pattern match:

awk , sed Experts, I want to remove first and last line after pattern match "vg" : I am trying : # sed '1d;$d' works fine , but where the last line is not having vg entry it is deleting one line of data. - So it should check for the pattern vg if present , then it should delete the line ,...

5. Shell Programming and Scripting

Remove the first match only in a file using sed

I'm trying to remove the first match only of 2Z694 from an xml file and replace with a blank File Example: </Phoenix_Response_Data> <Bundle_Name_Primary>2Z694</Bundle_Name_Primary> <Bundle_Name>2Z694</Bundle_Name> </Phoenix_Response_Data> tried using: sed -e 's/'2Z694'/''/1' but this...

6. UNIX for Dummies Questions & Answers

Match patterns from another file and tag

Hi all, I have a file , which has 6 tab delimited fields, with $3 and $4 subfielded with spaces. I wamt to match cols $2,$3,$4 of tmp1 with tmp2, ..and then flag the 5th col if found. tmp1 1756 Xerm XermA XermB XermC XermD AA TT AA GG A 1 1763 Xerm XermA XermB XermC...

7. Shell Programming and Scripting

Match multiple patterns sequentially in order - grep or awk

Hello. grep v2.21 Debian 8 I wish to search for and output these patterns in order; "From " "To: " "Subject: " "Message-Id: " "Date: " "To: " grep works, but not in strict order... $ grep -a -E "^From |^Subject:|^From: |^Message-Id: |^Date: |^To: " InboxResult; From - Wed Feb 18...

8. Shell Programming and Scripting

Using awk to remove lines from file that match text

I am trying to remove each line in which $2 is FP or RFP. I believe the below will remove one instance but not both. Thank you :). file 12 123 FP 11 10 RFP awk awk -F'\t' ' $2 != "FP"' file desired output 12 11

9. Shell Programming and Scripting

awk pattern match by looping through search patterns

Hi I am using Solaris 5.10 & ksh Wanted to loop through a pattern file by reading it and passing it to the awk to match that value present in column 1 of rawdata.txt , if so print column 1 & 2 in to Avlblpatterns.txt. Using the following code but it seems some mistakes and it is running for...

10. Shell Programming and Scripting

awk to print match or non-match and select fields/patterns for non-matches

In the awk below I am trying to output those lines that Match between file1 and file2, those Missing in file1, and those missing in file2. Using each $1,$2,$4,$5 value as a key to match on, that is if those 4 fields are found in both files the match, but if those 4 fields are not found then missing...

LEARN ABOUT CENTOS

alter_index

ALTER 
INDEX(7)						  PostgreSQL 9.2.7 Documentation					    ALTER INDEX(7)

NAME

       ALTER_INDEX - change the definition of an index

SYNOPSIS

       ALTER INDEX [ IF EXISTS ] name RENAME TO new_name
       ALTER INDEX [ IF EXISTS ] name SET TABLESPACE tablespace_name
       ALTER INDEX [ IF EXISTS ] name SET ( storage_parameter = value [, ... ] )
       ALTER INDEX [ IF EXISTS ] name RESET ( storage_parameter [, ... ] )

DESCRIPTION

       ALTER INDEX changes the definition of an existing index. There are several subforms:

       IF EXISTS
	   Do not throw an error if the index does not exist. A notice is issued in this case.

       RENAME
	   The RENAME form changes the name of the index. There is no effect on the stored data.

       SET TABLESPACE
	   This form changes the index's tablespace to the specified tablespace and moves the data file(s) associated with the index to the new
	   tablespace. See also CREATE TABLESPACE (CREATE_TABLESPACE(7)).

       SET ( storage_parameter = value [, ... ] )
	   This form changes one or more index-method-specific storage parameters for the index. See CREATE INDEX (CREATE_INDEX(7)) for details on
	   the available parameters. Note that the index contents will not be modified immediately by this command; depending on the parameter you
	   might need to rebuild the index with REINDEX(7) to get the desired effects.

       RESET ( storage_parameter [, ... ] )
	   This form resets one or more index-method-specific storage parameters to their defaults. As with SET, a REINDEX might be needed to
	   update the index entirely.

PARAMETERS

       name
	   The name (possibly schema-qualified) of an existing index to alter.

       new_name
	   The new name for the index.

       tablespace_name
	   The tablespace to which the index will be moved.

       storage_parameter
	   The name of an index-method-specific storage parameter.

       value
	   The new value for an index-method-specific storage parameter. This might be a number or a word depending on the parameter.

NOTES

       These operations are also possible using ALTER TABLE (ALTER_TABLE(7)).  ALTER INDEX is in fact just an alias for the forms of ALTER TABLE
       that apply to indexes.

       There was formerly an ALTER INDEX OWNER variant, but this is now ignored (with a warning). An index cannot have an owner different from its
       table's owner. Changing the table's owner automatically changes the index as well.

       Changing any part of a system catalog index is not permitted.

EXAMPLES

       To rename an existing index:

	   ALTER INDEX distributors RENAME TO suppliers;

       To move an index to a different tablespace:

	   ALTER INDEX distributors SET TABLESPACE fasttablespace;

       To change an index's fill factor (assuming that the index method supports it):

	   ALTER INDEX distributors SET (fillfactor = 75);
	   REINDEX INDEX distributors;

COMPATIBILITY

       ALTER INDEX is a PostgreSQL extension.

SEE ALSO

       CREATE INDEX (CREATE_INDEX(7)), REINDEX(7)

PostgreSQL 9.2.7						    2014-02-17							    ALTER INDEX(7)