Select only the lines of a file starting with a field which is matcing a list. awk? Post: 302916841

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

select last field from a file

hi everybody i would to select the last field of a file here as you can see i select the field number 8 y=`cat sortie2 | grep "^"| grep "starting"| awk '{ print $8}'` but line can containt more or less field in never know, i just know is the last one so i wondering to know if is...

2. UNIX for Dummies Questions & Answers

Awk - select from a list

Hi all, I am trying to select some columns from a file, based on the list of values. Would like to know how best I can achive this. If coulmn 1 has a value of 57 then print the ist column (This works) awk -F' ' '{if ( $1 == 57 ) {print $1}}' file.txt Now my requirement is that I have to...

3. Shell Programming and Scripting

Select some lines from a txt file and create a new file with awk

Hi there, I have a text file with several colums separated by "|;#" I need to search the file extracting all columns starting with the value of "1" or "2" saving in a separate file just the first 7 columns of each row maching the criteria, with replacement of the saparators in the nearly created...

4. Shell Programming and Scripting

Select lines in which column have value greater than some percent of total file lines

i have a file in following format 1 32 3 4 6 4 4 45 1 45 4 61 54 66 4 5 65 51 56 65 1 12 32 85 now here the total number of lines are 8(they vary each time) Now i want to select only those lines in which the values...

5. Shell Programming and Scripting

select lines with certain values on certain fields with awk

I need a awk command to select from a log-file only the lines that have on the 2nd field (considering "|" separator) one of the values 10.216.22.XX or 10.216.22.YY or 10.216.22.ZZ and on the 4th field only values that contain strictly digits. I want the command to work parsing the file only once (I...

6. Shell Programming and Scripting

awk - mixed for and if to select particular lines in a data file

Hi all, I am new to AWK and I am trying to solve a problem that is probably easy for an expert. Suppose I have the following data file input.txt: 20 35 43 20 23 54 20 62 21 20.5 43 12 20.5 33 11 20.5 89 87 21 33 20 21 22 21 21 56 87 I want to select from all lines having the...

7. Shell Programming and Scripting

Using awk to select one field

Hi, I saw your post.. I have a dought in awk command... how to get the output from a file. i need a first column in etc/passwd file in a single column (in indivijual line)... i couldn't get with this command cat /etc/passwd | awk -F ":" '{printf $1}' Kindly help This thread was created...

8. Shell Programming and Scripting

awk repeat one field at all lines and modify field repetitions

Hello experts I have a file with paragraphs begining with a keeping date and ending with "END": 20120301 num num John num num A keepnum1 num num kathrin num num A keepnum1 num num kathrin num num B keepnum2 num num Pete num num A keepnum1 num num Jacob num...

9. Shell Programming and Scripting

awk to remove lines in file if specific field matches

I am trying to remove lines in the target.txt file if $5 before the - in that file matches sorted_list. I have tried grep and awk. Thank you :). grep grep -v -F -f targets.bed sort_list grep -vFf sort_list targets awk awk -F, ' > FILENAME == ARGV {to_remove=1; next} > ! ($5 in...

10. UNIX for Dummies Questions & Answers

How to grep a line not starting with # from a file (there are two lines starting with # and normal)?

e.g. File name: File.txt cat File.txt Result: #INBOUND_QUEUE=FAQ1 INBOUND_QUEUE=FAQ2 I want to get the value for one which is not commented out. Thanks,

LEARN ABOUT REDHAT

pcregrep

PCREGREP(1)						      General Commands Manual						       PCREGREP(1)

NAME

       pcregrep - a grep with Perl-compatible regular expressions.

SYNOPSIS

       pcregrep [-Vcfhilnrsvx] pattern [file] ...

DESCRIPTION

       pcregrep  searches files for character patterns, in the same way as other grep commands do, but it uses the PCRE regular expression library
       to support patterns that are compatible with the regular expressions of Perl 5. See pcre(3) for a full description of syntax and semantics.

       If no files are specified, pcregrep reads the standard input. By default, each line that matches the pattern is copied to the standard out-
       put,  and  if  there is more than one file, the file name is printed before each line of output. However, there are options that can change
       how pcregrep behaves.

       Lines are limited to BUFSIZ characters. BUFSIZ is defined in <stdio.h>.	The newline character is removed from the end of each line  before
       it is matched against the pattern.

OPTIONS

       -V	 Write the version number of the PCRE library being used to the standard error stream.

       -c	 Do  not print individual lines; instead just print a count of the number of lines that would otherwise have been printed. If sev-
		 eral files are given, a count is printed for each of them.

       -ffilename
		 Read patterns from the file, one per line, and match all patterns against each line. There is a maximum of 100 patterns. Trailing
		 white space is removed, and blank lines are ignored. An empty file contains no patterns and therefore matches nothing.

       -h	 Suppress printing of filenames when searching multiple files.

       -i	 Ignore upper/lower case distinctions during comparisons.

       -l	 Instead  of  printing lines from the files, just print the names of the files containing lines that would have been printed. Each
		 file name is printed once, on a separate line.

       -n	 Precede each line by its line number in the file.

       -r	 If any file is a directory, recursively scan the files it contains. Without -r a directory is scanned as a normal file.

       -s	 Work silently, that is, display nothing except error messages.  The exit status indicates whether any matches were found.

       -v	 Invert the sense of the match, so that lines which do not match the pattern are now the ones that are found.

       -x	 Force the pattern to be anchored (it must start matching at the beginning of the line) and in addition, require it to	match  the
		 entire  line.	This  is  equivalent  to  having ^ and $ characters at the start and end of each alternative branch in the regular
		 expression.

SEE ALSO

       pcre(3), Perl 5 documentation

DIAGNOSTICS

       Exit status is 0 if any matches were found, 1 if no matches were found, and 2 for syntax errors or inacessible files (even if matches  were
       found).

AUTHOR

       Philip Hazel <ph10@cam.ac.uk>

       Last updated: 15 August 2001
       Copyright (c) 1997-2001 University of Cambridge.

																       PCREGREP(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

select last field from a file

Discussion started by: kykyboss

2. UNIX for Dummies Questions & Answers

Awk - select from a list

Discussion started by: simha77777

3. Shell Programming and Scripting

Select some lines from a txt file and create a new file with awk

Discussion started by: capnino

4. Shell Programming and Scripting

Select lines in which column have value greater than some percent of total file lines

Discussion started by: vaibhavkorde