Matching words based on column headers Post: 302456001

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing Headers and a Column

I have a text file in unix with a layout like this Column 1 - 1-12 Column 2 - 13-39 Column 3 - 40-58 Column 4 - 59-85 Column 5 - 86-120 Columbn 6 - 121-131 The file also has a header on the first 6 lines of each page. Each page is 51 lines long. So I want to remove the header from each...

2. Shell Programming and Scripting

printing words based on column match

pls help Input: file1 word1 text1 word2 text2 word3 text3 file2 word1 text11 word3 text13 can u pls help in getting the same output: file1 text1 text2 text3

3. Shell Programming and Scripting

Matching 2 files based on one column

Hi, On a similar subject, the following. I have two files: file1.txt dbSNP_rsID,Chromosome,Position,Gene rs10399749,chr. 01,45162,? rs4030303,chr. 01,72434,? rs4030300,chr. 01,72515,? rs940550,chr. 01,78032,? rs13328714,chr. 01,81468,? rs11490937,chr. 01,222077,? rs6683466,chr....

4. UNIX for Dummies Questions & Answers

Removing Lines based on matching first column

I have a file1 that looks like this: File 1 a b b c c e d e and a file 2 that looks like this: File 2 b c e e Note that file 2 is the right hand column from file1. I want to remove any lines from file1 that begin with the column in file2. In this case the desired output...

5. Shell Programming and Scripting

Transpose field names from column headers to values in one column

Hi All, I'm looking for a script which can transpose field names from column headers to values in one column. for example, the input is: IDa;IDb;IDc;PARAM1;PARAM2;PARAM3; a;b;c;p1val;p2val;p3val; d;e;f;p4val;p5val;p6val; g;h;i;p7val;p8val;p9val; into the output like this: ...

6. Shell Programming and Scripting

Replacing headers based on a second file

I have a file with thousands of sequences that looks like this: I need to replace the headers using a second file Thus, I will end up having the following file: I am looking for an AWK script that I can easily plug in my current pipeline. Any help will be greatly appreciated!

7. Shell Programming and Scripting

awk print non matching lines based on column

My item was not answered on previous thread as code given did not work I wanted to print records from file2 where comparing column 1 and 16 for both files find rows where column 16 in file 1 does not match column 16 in file 2 Here was CODE give to issue ~/unix.com$ cat f1...

8. Shell Programming and Scripting

Based on column in file1, find match in file2 and print matching lines

file1: file2: I need to find matches for any lines in file1 that appear in file2. Desired output is '>' plus the file1 term, followed by the line after the match in file2 (so the title is a little misleading): This is honestly beyond what I can do without spending the whole night on it, so I'm...

9. Shell Programming and Scripting

Insert value of column based on file name matching

At the top of the XYZ file, I need to insert the ABC data value of column 2 only when ABC column 1 matches the prefix XYZ file name (not the ".txt"). Is there an awk solution for this? ABC Data 0101 0.54 0102 0.48 0103 1.63 XYZ File Name 0101.txt 0102.txt 0103.txt ...

10. Shell Programming and Scripting

Replace particular words in file based on if finds another words in that line

Hi All, I need one help to replace particular words in file based on if finds another words in that file . i.e. my self is peter@king. i am staying at north sydney. we all are peter@king. How to replace peter to sham if it finds @king in any line of that file. Please help me...

LEARN ABOUT SUSE

drop_text_search_configuration

DROP TEXT SEARCH 
CONFIGURATION(7)				   SQL Commands 				 DROP TEXT SEARCH CONFIGURATION(7)

NAME

       DROP TEXT SEARCH CONFIGURATION - remove a text search configuration

SYNOPSIS

       DROP TEXT SEARCH CONFIGURATION [ IF EXISTS ] name [ CASCADE | RESTRICT ]

DESCRIPTION

       DROP TEXT SEARCH CONFIGURATION drops an existing text search configuration. To execute this command you must be the owner of the configura-
       tion.

PARAMETERS

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

       name   The name (optionally schema-qualified) of an existing text search configuration.

       CASCADE
	      Automatically drop objects that depend on the text search configuration.

       RESTRICT
	      Refuse to drop the text search configuration if any objects depend on it.  This is the default.

EXAMPLES

       Remove the text search configuration my_english:

       DROP TEXT SEARCH CONFIGURATION my_english;

       This command will not succeed if there are any existing indexes that reference the configuration in to_tsvector calls.  Add CASCADE to drop
       such indexes along with the text search configuration.

COMPATIBILITY

       There is no DROP TEXT SEARCH CONFIGURATION statement in the SQL standard.

SEE ALSO

       ALTER  TEXT  SEARCH  CONFIGURATION  [alter_text_search_configuration(7)],  CREATE  TEXT SEARCH CONFIGURATION [create_text_search_configura-
       tion(7)]

SQL - Language Statements					    2010-05-14					 DROP TEXT SEARCH CONFIGURATION(7)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Removing Headers and a Column

Discussion started by: DerangedNick

2. Shell Programming and Scripting

printing words based on column match

Discussion started by: bha148

3. Shell Programming and Scripting

Matching 2 files based on one column

Discussion started by: swvanderlaan

4. UNIX for Dummies Questions & Answers

Removing Lines based on matching first column

Discussion started by: kschiltz55