Sponsored Content
Top Forums Shell Programming and Scripting How do I select certain columns with matching pattern and rest of the lines? Post 302989740 by Don Cragun on Tuesday 17th of January 2017 04:44:46 PM
Old 01-17-2017
If I correctly understand what you're trying to do (and I am not at all sure that I do), try:
Code:
awk '/key2/ || /key3/{print $2,$3; next}1' file

or:
Code:
awk '/key[23]/{print $2,$3; next}1' file

As always, if you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk or nawk.
This User Gave Thanks to Don Cragun For This Post:
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to select lines in unix matches a pattern at a particular position

I have huge file. I want to copy the lines which have first character as 2 or 7, and also which has fist two characters as 90. I need only these records from file. How I can acheive this. Can somebody help me..... (2 Replies)
Discussion started by: cs_banda
2 Replies

2. UNIX for Dummies Questions & Answers

exclude columns with a matching line pattern

Hi , I have 5 columns total and am wanting to search lines in columns 3-5 and basically grep -v patterns that match 'BBB_0123' 'BVG_0895' 'BSD_0987' Does anyone know how to do this? I tried combining grep -v with grep -e but, it didn't work. Thanks! (5 Replies)
Discussion started by: greptastic
5 Replies

3. Shell Programming and Scripting

counting the lines matching a pattern, in between two pattern, and generate a tab

Hi all, I'm looking for some help. I have a file (very long) that is organized like below: >Cluster 0 0 283nt, >01_FRYJ6ZM12HMXZS... at +/99% 1 279nt, >01_FRYJ6ZM12HN12A... at +/99% 2 281nt, >01_FRYJ6ZM12HM4TS... at +/99% 3 283nt, >01_FRYJ6ZM12HM946... at +/99% 4 279nt,... (4 Replies)
Discussion started by: d.chauliac
4 Replies

4. Shell Programming and Scripting

using command line arguments as columns for pattern matching using awk

Hi, I wish to use a column, as inputted by a user from command line, for pattern matching. awk file: { if($1 ~ /^8/) { print $0> "temp2.csv" } } something like this, but i want '$1' to be any column as selected by the user from command line. ... (1 Reply)
Discussion started by: invinclible0009
1 Replies

5. Shell Programming and Scripting

pattern matching lines using the date, and then joining the lines

Hi Guys, Was trying to attempt the below using awk and sed, have no luck so far, so any help would be appreciated. Current Text File: The first line has got an "\n", and the second line has got spaces/tabs then the word and "\n" TIME SERVER/CLIENT TEXT... (6 Replies)
Discussion started by: eo29
6 Replies

6. Shell Programming and Scripting

Finding lines matching the Pattern and their previous lines in a file

Hi, I am trying to locate the occurences of certain pattern like 'Possible network disconnect' in a text file. I can get the actual lines matching the pttern using: grep -w 'Possible network disconnect' file_name. But I am more interested in getting the timing of these events which are... (7 Replies)
Discussion started by: sagarparadkar
7 Replies

7. Shell Programming and Scripting

Select lines where at least x columns above threshold value

I have a file with 20 columns. I'd like to retain only the lines for which the values in at least x columns, looking only at columns 6-20, are above a threshold. For example, I'd like to retain only the lines in the file below that have at least 8 columns (again, looking only at columns 6-20)... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

8. Shell Programming and Scripting

Sed: printing lines AFTER pattern matching EXCLUDING the line containing the pattern

'Hi I'm using the following code to extract the lines(and redirect them to a txt file) after the pattern match. But the output is inclusive of the line with pattern match. Which option is to be used to exclude the line containing the pattern? sed -n '/Conn.*User/,$p' > consumers.txt (11 Replies)
Discussion started by: essem
11 Replies

9. Shell Programming and Scripting

awk - matching on 2 columns for differents lines

Given this file (I separated them in block to make my explanation clearer): 92157768877;Sof_deme_Fort_Email_am_%yyyy%%mm%%dd%;EMAIL;20/02/2015;1;0;0 92157768877;Sof_trav_Fort_Email_am_%yyyy%%mm%%dd%;EMAIL;20/02/2015;1;0;0 91231838895;Sof_deme_faible_Email_am;EMAIL;26/01/2015;1 0;0... (1 Reply)
Discussion started by: Andy_K
1 Replies

10. UNIX for Dummies Questions & Answers

Grep -v lines starting with pattern 1 and not matching pattern 2

Hi all! Thanks for taking the time to view this! I want to grep out all lines of a file that starts with pattern 1 but also does not match with the second pattern. Example: Drink a soda Eat a banana Eat multiple bananas Drink an apple juice Eat an apple Eat multiple apples I... (8 Replies)
Discussion started by: demmel
8 Replies
ppdof(8)						      System Manager's Manual							  ppdof(8)

NAME
ppdof - Text to PostScript translation filter SYNOPSIS
/usr/lbin/ppdof +Cfilename [-n login] [-h host] [...] OPTIONS
Use of the print flags is dependent on the features available on the print device, and on the current status of those features. For exam- ple, when you select a particular paper size, the appropriate paper must be correctly loaded in the paper trays. Options in /etc/printcap The following options are set in the /etc/printcap file and can be specified using the + switch. For example: :if=/usr/lbin/ppdof +Bupper +Cln32.rpd: You can also specify command line options in the /etc/printcap file using the + switch. For example: :if=/usr/lbin/ppdof +Olandscape +Cln32.rpd: Here, the -Olandscape option is specified. Specifies the default tray name to select for printing the banner page. For example: :of=/usr/lbin/ppdof +Bupper +Cln32.rpd: In this example, the banner page will be printed on whatever stock is currently loaded into the upper tray on the selected print device. Specifies the printer configuration file to use for the print job. Specifies the unit of measurement to be inches or cen- timeters for lines per inch (lpi), characters per inch (cpi), and page margin options. The default value is inches. Specifies the default tray name to select for printing the trailer page. For example: :if=/usr/lbin/ppdof +olower +Cln32.rpd: Command Line Options Specify print filter options at the command line using the lpr command as follows. Multiple -O options are supported. Specifies the host name from which the job owner is submitting the print command. Specifies the login (account) name of the job owner. Specifies the name of the output tray where the printed pages are placed. Specifies the page width in columns for portrait and landscape printing. A page width of 0 instructs the filter to use 80 columns in portrait orientation and 132 columns in landscape orientation. Specifies the tray name from which print paper is selected. The printer may select an alternate tray when the paper size provided in the tray does not match the docu- ment requirements. Specifies the number of sides to print on each sheet. You can specify sides as follows: 1 or one - Print on one side of the sheet. 2 or two - Print on both sides of the sheet (duplex printing). Specifies options related to page orientation, formatting, and features as follows: Specifies the number of characters to print per inch. Specifies only even numbered sheets are to be printed. Speci- fies the printed output is parallel to the long side of the page. Specifies the number of lines to print per page. Specifies the number of lines to print per inch. Specifies only odd numbered sheets are to be printed. Specifies the range of pages to be printed, starting with page number m and ending with page number n. Specifies to print the list of options provided by the printer configuration file which includes paper sizes, input and output paper tray names. For example: # lpr -Oprint /etc/motd (Note that the file /etc/motd is specified to satisfy lpr command line requirements, the file itself is not printed.) Specifies the printed output is parallel to the short side of the page. These options specify the various page margins in inches. The page mar- gin sizes in inches as follows: tm= - Top margin in inches. For example -Otm=2 bm= - Bottom margin in inches. For example -Obm=1.5 lm= - Left margin in inches. For example -Olm=1 rm= - Right margin in inches. For example -Orm=3 pm= - Page margin. Using this option sets tm, bm, lm and rm to the same value. For example -Opm=1.25 When configuring the /etc/printcap entry, different margins for landscape and portrait orientation can be specified by adding the suffixes _l and _p respectively. For example: :if=/usr/lbin/ppdof +Olm_p=0.5 +Olm_l=0.25 +Cln32.rpd: DESCRIPTION
The ppdof filter translates ASCII to PostScript and handles the device dependencies of a PostScript printer. It is recommended that the ppdof filter be specified for both the :of and the :if fields in the /etc/printcap file. For a description of these fields, see the printcap(4) reference page. RESTRICTIONS
The commands generated by the ppdof filter to handle device dependencies might be incompatible with some PostScript documents. When a PostScript file does not print correctly use the following command to prevent file preprocessing. # lpr -x file.ps The filter will not setup device dependencies or provide ASCII to PostScript translation for documents containing printer control charac- ters. EXIT STATUS
Any value other than zero (0) indicates that an error has occurred. ERRORS
Use the lf error log field in the /etc/printcap to specify the name of the error log file. SEE ALSO
Commands: cancel(1), lpr(1), pr(1) Files: printcap(4). System Administration ppdof(8)
All times are GMT -4. The time now is 02:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy