|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
How to compare 2 files & get only few columns based on a condition related to both files?
Post 302379210 by reva on Wednesday 9th of December 2009 11:57:19 PM
12-10-2009
I tried to do like this already..It deletes my other data..
for example
a.dat:
b.dat:
The correct output i should get is
c.dat:
but if i use your code i get output for such lines as
&
if i use your first code which is thier i get output as
for example
a.dat:
HTML Code:
2009 10 29 17 44 31.00 70.66 36.40 286 24 76 2009 11 7 20 9 4.00 86.22 29.29 172 43 -105 2009 11 10 2 48 46.00 91.86 8.08 123 78 169
HTML Code:
PDE-Q 2009 10 29 17 0 38.84 27.2600 91.3800 26.0 0 5.20 0 0.00 0.00 0.00 0 0.00 5.20 0 NULL PDE-Q 2009 10 29 17 44 31.75 36.4300 70.7300 205.0 0 6.20 0 0.00 0.00 0.00 0 0.00 6.20 0 NULL PDE-Q 2009 11 7 20 8 46.72 29.5200 86.0600 7.0 0 5.60 0 0.00 0.00 0.00 0 0.00 5.60 0 NULL PDE-Q 2009 11 10 2 48 46.87 8.0800 91.8900 23.0 0 6.00 0 0.00 0.00 0.00 0 0.00 6.00 0 NULL
c.dat:
HTML Code:
36.4300 70.7300 6.20 286 24 76 29.5200 86.0600 5.60 172 43 -105 8.0800 91.8900 6.00 123 78 169
HTML Code:
36.4300 70.7300 6.20 286 24 76 8.0800 91.8900 6.00 123 78 169
if i use your first code which is thier i get output as
HTML Code:
27.2600 91.3800 5.20 286 24 76 36.4300 70.7300 6.20 286 24 76 29.5200 86.0600 5.60 172 43 -105 8.0800 91.8900 6.00 123 78 169
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Friends,
I am new to UNIX. I need to merge all the files(to FINAL.txt) in single directory based one condition. Out of all the files one of file will have specific value like :GF01: at any where in the file.
so the file which is having :GF01: should be appended at the last.
EX:... (5 Replies)
Discussion started by: arund_01
5 Replies
2. UNIX for Dummies Questions & Answers
Hiiii Friends
I have 2 files with huge data. I want to compare this 2 files & if they hav same set of vales in specific rows & columns i need to get that value from one file & replace it in other.
For example: I have few set data of both files here:
a.dat:
PDE-W 2009 12 16 5 29 11.11 ... (10 Replies)
Discussion started by: reva
10 Replies
3. Shell Programming and Scripting
I have a control file which tells me which are the fields in the files I need to compare and based on the values I need to print the exact value if key =Y and output is Y , or if output is Y/N then I need to print only Y if it matches or N if it does not match and if output =N , then skip the feild... (7 Replies)
Discussion started by: newtoawk
7 Replies
4. Shell Programming and Scripting
Hi Experts,
Is there a way to compare 2 files by columns and print matching cases.
I have 2 files as below, I want cases where col1 and col2 in f1 matches col1 and col2 in f2 to be printed as output. The separator is space. I want the output to have col1 col2 col 3 from both files printed... (7 Replies)
Discussion started by: novice_man
7 Replies
5. Shell Programming and Scripting
I have 2 files whose data's are as follows :
fileA
00 lieferungen
00 attractiop
01 done
02 forness
03 rasp
04 alwaysisng
04 funny
05 done1
fileB
alwayssng
dkhf
fdgdfg
dfgdg
sdjkgkdfjg
funny
rasp (7 Replies)
Discussion started by: rajniman
7 Replies
6. UNIX for Dummies Questions & Answers
hi
i have to move files and send an email and attached the bad files to inform the developer about that.
#!/bin/ksh
BASE_DIR=/data/SrcFiles
cd $BASE_DIR
## finding the files from work directory which are changed in 1 day
find -type f -name "*.csv" –ctime 0 > /home/mydir/flist.txt
##... (14 Replies)
Discussion started by: awais290
14 Replies
7. Shell Programming and Scripting
hi
my problem is little complicated one. i have 2 files which appear like this
file 1
abbsss:aa:22:34:as akl abc 1234
mkilll:as:ss:23:qs asc abc 0987
mlopii:cd:wq:24:as asd abc 7866
file2
lkoaa:as:24:32:sa alk abc 3245
lkmo:as:34:43:qs qsa abc 0987
kloia:ds:45:56:sa acq abc 7805
i... (5 Replies)
Discussion started by: anurupa777
5 Replies
8. Shell Programming and Scripting
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Discussion started by: bkane3
5 Replies
9. UNIX for Beginners Questions & Answers
Hello there.
I am trying to compare two files.
File1
Austria Mobile 1
United Kingdom Mobile 1
...
File2
Austria Mobile Vien 2
Austria Mobile Ostr 0
United Kingdom Mobile Dev 0.7
United Kingdom Mobile OST 1.5
What i want to do is to compare both files and... (12 Replies)
Discussion started by: dragonfly85
12 Replies
10. UNIX for Beginners Questions & Answers
I am preparing a script to check the configuration of the db2 against the standard configuration. I am fetching the output in file A and want to compare it with the standard output written in file B.
File A
Diagnostic error capture level (DIAGLEVEL) = 3
Audit buffer size (4KB) (AUDIT_BUF_SZ)... (2 Replies)
Discussion started by: bashb
2 Replies
LEARN ABOUT DEBIAN
plotit
plotit(1) General Commands Manual plotit(1) NAME
plotit - experiment data visualization SYNOPSIS
plotit -w FILE plotit [-lp] -q FILE [FILE]... plotit [-lp] Y FILE [FILE...] plotit [-lp] X Y FILE [FILE...] DESCRIPTION
The plotit program is a simple plotting program which can draw line plots and stripcharts using a command language similar to that of gnu- plot. It can also make quick plots of multiple data files from the command-line. Wildcards may be used in the file names. The program takes optional expressions which can be used to manipulate data columns before plotting. Expressions may be as simple as the designation of a column to be plotted or may contain arithmetic expressions and functions. In the latter case the espression must be enclosed in 'single' or "double" quotation marks. Column numbers are designated by the at-sign character (@). A single expression is used for the Y axis of the plot. OPTIONS
-h, --help Print the usage and exit. --version Print the version number and exit. -w Watch the input file for commands to stripchart, or wait to read all of stdin before plotting. Only one file or - for stdin may be specified with this option. No other options may be used in conjuction with this option. -q Plot the first and second columns of each file. -l Plot with lines. -p Plot with points. EXAMPLES
Plot the second column versus the first of all three files with lines only. plotit -lq file1.dat file2.dat file3.dat Plot the quotient of the third column and the second column versus the first column of all files matching the pattern using points only. plotit -p '@3/@2' file??.dat Plot the natural log of the second column divided by the third column versus the fourth column. By default these data are plotted with both lines and points. plotit @4 'log(@2/@3)' file.dat AUTHOR
This manual page was written by Carlo Segre <segre@iit.edu>. February 21, 2009 plotit(1)