The first part of the code
is reading and storing the contents of $1 from file2 into an array called m. So this will be made up of all the 2014* values.
The second part of the code
is what is run for each line in file1. It basically says for each line beginning with a 2 (I made the assumption from the data provided by OP that each value in file2 would start with 2014, so in effect this can be elaborated to /^2014/ OR /^201/), check to see if this 2014* value (ie. $1) is in the array m. Set x to the return code of the 'in array' function which will exit 1 if true and 0 is false. Then pass x outside the action block to perform the default action of printing the line, when x is not 0.
Hope this helps, sorry if I have confused things more!
thx for your explanation, but i don't understand how the output print the line between the line which begin by 2
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... (3 Replies)
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... (14 Replies)
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 Replies)
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... (6 Replies)
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... (2 Replies)
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... (4 Replies)
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... (3 Replies)
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... (2 Replies)
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... (2 Replies)
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, (3 Replies)
Discussion started by: Tanu
3 Replies
LEARN ABOUT MINIX
paste
PASTE(1) General Commands Manual PASTE(1)NAME
paste - paste multiple files together
SYNOPSIS
paste [-s] [-d list] file...
OPTIONS -d Set delimiter used to separate columns to list.
-s Print files sequentially, file k on line k.
EXAMPLES
paste file1 file2 # Print file1 in col 1, file2 in col 2
paste -s f1 f2 # Print f1 on line 1 and f2 on line 2
paste -d : file1 file2
# Print the lines separated by a colon
DESCRIPTION
Paste concatenates corresponding lines of the given input files and writes them to standard output. The lines of the different files are
separated by the delimiters given with the option -s. If no list is given, a tab is substituted for every linefeed, except the last one.
If end-of-file is hit on an input file, subsequent lines are empty. Suppose a set of k files each has one word per line. Then the paste
output will have k columns, with the contents of file j in column j. If the -s flag is given, then the first file is on line 1, the second
file on line 2, etc. In effect, -s turns the output sideways.
If a list of delimiters is given, they are used in turn. The C escape sequences
, , \, and are used for linefeed, tab, backslash,
and the null string, respectively.
PASTE(1)