Sponsored Content
Operating Systems Linux How to remove lines without a particular string in either column? Post 302958063 by Syeda Sumayya on Monday 19th of October 2015 06:04:10 AM
Old 10-19-2015
How to remove lines without a particular string in either column?

I have a file that looks like this:

Code:
DIP-27772N       DIP-18408N refseq:NP_523941
DIP-23436N|refseq:NP_536784       DIP-23130N|refseq:NP_652017
DIP-22958N|refseq:NP_651195       DIP-20072N|refseq:NP_724597
DIP-22928N|refseq:NP_569972       DIP-22042N|refseq:NP_536744|uniprotkb:P54622
DIP-20065N|refseq:NP_731331       DIP-17103N

I want to remove those lines that do not contain "refseq:NP" in either column (the 1st and last line in the given example)

required output

Code:
DIP-23436N|refseq:NP_536784       DIP-23130N|refseq:NP_652017
DIP-22958N|refseq:NP_651195       DIP-20072N|refseq:NP_724597
DIP-22928N|refseq:NP_569972       DIP-22042N|refseq:NP_536744|uniprotkb:P54622

How can I do it using grep? Any help would be highly appreciated.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to remove a string from a specific column in a file

Hello, A basic query. How can I remove a string from a specific column. For example, remove "abcd" just from column 2 in example file: abcd abcd1 abcd abcd2 abcd abcd3 to get output: abcd 1 abcd 2 abcd 3 Thank you!:) (4 Replies)
Discussion started by: auburn
4 Replies

2. Shell Programming and Scripting

Remove lines based on column value

Hi All, I just need a quick fix here. I need to delete all lines containing "." in the 6th column. Input: 1 1055498 . G T 5.46 . 1 1902377 . C T 7.80 . 1 1031540 . A G 34.01 PASS 1 ... (2 Replies)
Discussion started by: Hkins552
2 Replies

3. Shell Programming and Scripting

Remove lines that match string at end of column

I have this: 301205 0000030000041.49000000.00 2011111815505 908 301205 0000020000029.10000000.00 2011111815505 962 301205 0000010000027.56000000.00 2011111815505 3083 312291 ... (2 Replies)
Discussion started by: herot
2 Replies

4. UNIX for Dummies Questions & Answers

[SOLVED] remove lines that have duplicate values in column two

Hi, I've got a file that I'd like to uniquely sort based on column 2 (values in column 2 begin with "comp"). I tried sort -t -nuk2,3 file.txtBut got: sort: multi-character tab `-nuk2,3' "man sort" did not help me out Any pointers? Input: Output: (5 Replies)
Discussion started by: pathunkathunk
5 Replies

5. UNIX for Dummies Questions & Answers

Remove lines contain certain string

i have file input aa,20120626 bb,45Cexpect to remove all lines when $2 doesn't end with 'C" output bb,45Ci tried this sed -i -nl -e '/\<C\>/ {p;} ' file1 but the result : sed illegal option -i (5 Replies)
Discussion started by: radius
5 Replies

6. UNIX for Dummies Questions & Answers

Remove lines in a positional file based on string value

Gurus, I am relatively new to Unix scripting and am struck with a problem in my script. I have positional input file which has a FLAG indicator in at position 11 in every record of the file. If the Flag has value =Y, then the record from the input needs to be written to a new file.However if... (3 Replies)
Discussion started by: gsam
3 Replies

7. Shell Programming and Scripting

Remove multiple lines from a particular string to particular string

Hi, I have a file containing the DDLs of tables in a schema. From that I need to remove all the lines from a starting string till a specific string. Here is an example. File1.txt ------------- CREATE TABLE "SCHEMA1"."LKP11_TBL_USERS" ( "ID" NUMBER(8,0) NOT NULL ENABLE, "USER_ID"... (3 Replies)
Discussion started by: satyaatcgi
3 Replies

8. Shell Programming and Scripting

Remove lines matching a substring in a specific column

Dear group, I have following input text file: Brit 2016 11 18 12 00 10 1.485,00 EUR Brit 2016 11 18 12 00 10 142,64 EUR Brit 2016 11 18 12 00 10 19,80 EUR Brit 2016 11 18 12 00 10 545,00 EUR Brit 2016 11 18 12 00 10 6.450,00 EUR... (3 Replies)
Discussion started by: gfhsd
3 Replies

9. Shell Programming and Scripting

Remove duplicate consecutive lines with specific string

Hello, I'm trying to remove the duplicate consecutive lines with specific string "WARNING". File.txt abc; WARNING 2345 WARNING 2345 WARNING 2345 WARNING 2345 WARNING 2345 bcd; abc; 123 123 123 WARNING 1234 WARNING 2345 WARNING 2345 efgh; (6 Replies)
Discussion started by: Mannu2525
6 Replies

10. UNIX for Beginners Questions & Answers

Remove newline character from column spread over multiple lines in a file

Hi, I came across one issue recently where output from one of the columns of the table from where i am creating input file has newline characters hence, record in the file is spread over multiple lines. Fields in the file are separated by pipe (|) delimiter. As header will never have newline... (4 Replies)
Discussion started by: Prathmesh
4 Replies
PCII(4) 						   BSD Kernel Interfaces Manual 						   PCII(4)

NAME
pcii -- National Instruments PCIIA GPIB controller driver SYNOPSIS
device pcii In /boot/device.hints: hint.pcii.0.at="isa" hint.pcii.0.port="0x2e1" hint.pcii.0.irq="7" hint.pcii.0.drq="1" DESCRIPTION
The pcii driver provides support for driving an IEEE-488 bus, also called IEC-625 (or just "IEC bus"), or HP-IB (Hewlett Packard Instrument Bus), or GPIB (General Purpose Instrument Bus). The driver supports National Instruments PCIIA cards (sometimes also referred to as PC2A) and compatibles. These cards use a NEC uPD7210 controller IC as the main interface between the host computer and the instrument bus. IO memory space layout The PCIIA cards use a very specific IO memory space allocation layout. The address bits A0 through A9 (which have traditionally been the only address bits evaluated on IBM PC XT extension cards) are hardwired to address 0x2e1. Bits A10 through A12 are used by the uPD7210 reg- ister select lines. This makes the individual 7210 registers being 0x400 bytes apart in the ISA bus address space. Address bits A13 and A14 are compared to a DIP switch setting on the card, allowing for up to 4 different cards being installed (at base addresses 0x2e1, 0x22e1, 0x42e1, and 0x62e1, respectively). A15 has been used to select an optional on-board time-of-day clock chip (MM58167A) on the original PCIIA rather than the uPD7210 (which is not implemented on later boards and clones). Finally, the IO addresses 0x2f0 ... 0x2f7 are used for a special interrupt handling feature (re-enable interrupts so the IRQ can be shared), where actually only address 0x2f0 plus the actual IRQ level is required for each card. Some clones do not appear to require this special IRQ handling, and are thus likely to not support the shared IRQ feature. Only the base address of the card needs to be specified in the ISA device hints; the driver takes care to derive all other IO addresses needed during the probe phase. Supported cards The following cards are known to be supported: o B&C Microsystems PC488A-0 o National Instruments GPIB-PCII/PCIIA (in PCIIa mode) o Axiom AX5488 SEE ALSO
gpib(3), gpib(4), device.hints(5) HISTORY
The pcii driver was written by Poul-Henning Kamp, and first appeared in FreeBSD 5.4. AUTHORS
This manual page was written by Jorg Wunsch. BSD
January 24, 2010 BSD
All times are GMT -4. The time now is 05:39 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy