12-10-2009
I tried to do like this already..It deletes my other data..
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
b.dat:
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
The correct output i should get is
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
but if i use your code i get output for such lines as
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