Compare 1st column from 2 file and if match print line from 1st file and append column 7 from 2nd
hi
I have 2 file with more than 10 columns for both
1st file
2nd file
I want to match the first column of both file and if it matches, print the whole line from 1st file and append 7th column from 2nd file to it for everyline so it becomes like this
Any help would be much appreciated
Moderator's Comments:
code tags please
Last edited by jim mcnamara; 03-14-2019 at 11:05 AM..
ex:
a file has :
122323
123456456
125656879
678989965t635
234323432
b has :
this is finance no.
this is phone no
this is extn
ajkdgag
idjsidj
i want the o/p as:
122323 his is finance no.
123456456 this is phone no
123456456 ... (4 Replies)
I'm having problems since few days ago, and i'm not able to make it works with a simple awk+grep script (or other way to do this).
For example, i have a input file1.txt:
cat inputfile1.txt
218299910417
1172051195
1172070231
1172073514
1183135117
1183135118
1183135119
1281440202
... (3 Replies)
Hi,
I have two files. 1st file has 1 column (huge file containing ~19200000 lines) and 2nd file has 2 columns (small file containing ~6000 lines).
#################################
huge_file.txt
a
a
ab
b
##################################
small_file.txt
a 1.5
b 2.5
ab ... (4 Replies)
Hi Experts,
I am very new to scripting and have a prb since few days and it is urgent to solve so much appreciated if u help me.
i have 2 files
file1.txt
9647810043118
9647810043126
9647810043155
9647810043161
9647810043166
9647810043185
9647810043200
9647810043203
9647810043250... (22 Replies)
Hi friends,
My file is like:
Second file is :
I need to print the rows present in file one, but in order present in second file....I used
while read gh;do
awk ' $1=="' $gh'" {print >> FILENAME"output"} ' cat listoffirstfile
done < secondfile
but the output I am... (14 Replies)
Hi everyone. I need to change a script (ksh) so that it will grep on the 1st 2 letters in the second column of a 5 column file such as this one:
192.168.1.1 CAXY0_123 10ABFL000001 # Comment
192.168.1.2 CAYZ0_123 10ABTX000002 # Comment
192.168.2.1 FLXY0_123 11ABCA000001 ... (4 Replies)
Hi all,
I have a log file say Test.log that gets updated continuously and it has data in pipe separated format. A sample log file would look like:
<date1>|<data1>|<url1>|<result1>
<date2>|<data2>|<url2>|<result2>
<date3>|<data3>|<url3>|<result3>
<date4>|<data4>|<url4>|<result4>
What I... (3 Replies)
I have file that looks like this,
DIP-17571N|refseq:NP_651151 DIP-17460N|refseq:NP_511165|uniprotkb:P45890 DIP-17571N|refseq:NP_651151
DIP-19241N|refseq:NP_524261 DIP-19241N|refseq:NP_524261 DIP-17151N|refseq:NP_524316|uniprotkb:O16797
DIP-19588N|refseq:NP_731165 ... (2 Replies)
I have a file with class c IP addresses that I need to match to a column and print the matching lines of another file.
I started playing with grep -if file01.out file02.out but I am stuck as to how to match it to a column and print the matching lines;
cat file01.out
10.150.140... (5 Replies)
Discussion started by: lewk
5 Replies
LEARN ABOUT DEBIAN
ngraph
NGRAPH(1) General Commands Manual NGRAPH(1)NAME
Ngraph - creating scientific 2-dimensional graphs
SYNOPSIS
ngraph [options] [data file(s) or ngp file]
DESCRIPTION
Ngraph is the program to create scientific 2-dimensional graphs for researchers and engineers. Graphs can be exported to PostScript, SVG,
PNG or PDF format.
OPTIONS
Command line options are:
-L file
load ngp file
-x column
data column for the x axis
-y column
data column for the y axis
-X use X axis as the x axis
-Y use Y axis as the y axis
-U use U axis as the x axis
-R use R axis as the y axis
-d {mark | line | polygon | curve | diagonal | arrow | rectangle | rectangle_fill | rectangle_solid_fill | errorbar_x | errorbar_y | stair-
case_x | staircase_y | bar_x | bar_y | bar_fill_x | bar_fill_y | bar_solid_fill_x | bar_solid_fill_y | fit}
specify plot type
-m type
specify mark type (0-89)
-o size
specify mark size
-l style
specify line style
-w width
specify line width
-CR n specify red component of the 1st plot color (0-255)
-CG n specify green component of the 1st plot color (0-255)
-CB n specify blue component of the 1st plot color (0-255)
-cr n specify red component of the 2nd plot color (0-255)
-cg n specify green component of the 2nd plot color (0-255)
-cb n specify blue component of the 2nd plot color (0-255)
-s line
specify number of the head skip
-r step
specify number of the read step
-f line
specify number of the final line
-vx n neighbor average of the x data
-vy n neighbor average of the y data
-mx formula
specify math transformation for the x data
-my formula
specify math transformation for the y data
-ex {linear | log | inverse | MJD}
specify scale type of the x axis
-ey {linear | log | inverse | MJD}
specify scale type of the y axis
-minx value
specify minimum value of x axis
-maxx value
specify maximum value of x axis
-incx value
specify increment value of x axis
-miny value
specify minimum value of y axis
-maxy value
specify maximum value of y axis
-incy value
specify increment value of y axis
-g load settings from data file
-png file
convert ngp file to PNG format
-pdf file
convert ngp file to PDF format
-ps file
convert ngp file to PostScript format
-eps file
convert ngp file to Encapsulated PostScript format
-svg file
convert ngp file to SVG format
-gra file
convert ngp file to GRA format
-dialog
show print dialog (with -p option)
-p file
print ngp file
-n output ngp-file to stdout
-h, --help
show help message
-v, --version
show version of Ngraph
-V, --VERSION
show detail information about Ngraph
FILES
${HOME}/.Ngraph/Ngraph.nsc
start up script
${HOME}/.Ngraph/Ngraph.ini
configuration file
${HOME}/.Ngraph/Ngraph.ngp
default graph
AUTHORS
Satoshi ISHIZAKA
Hiroyuki Ito <ZXB01226@nifty.com>
SEE ALSO ngp2(1)COPYRIGHT
Copyright (C) 2003 Satoshi ISHIZAKA
Copyright (C) 2008-2011 Hiroyuki Ito
4th Berkeley Distribution Local NGRAPH(1)