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 302378929 by reva on Wednesday 9th of December 2009 05:55:24 AM
Old 12-09-2009
Bug

Thanks a lot...Its working...
But if my data of b.dat is as follows
HTML Code:
   PDE 2009  6  6  9  6 21.30  37.6300  21.0100  15.0   0 3.80   0 0.00 0.00  0.00   0  0.00  3.80   0   NULL
   PDE 2009  6  6  9 44 41.05  30.1900  86.2700  48.0   0 4.00   0 0.00 0.00  0.00   0  0.00  4.00   0   NULL
&
a.dat is as follows
HTML Code:
2009  6  6  9 44 37.00  86.43  30.99  218  76    -9
Then how to get out put as
HTML Code:
30.1900  86.2700  4.00  218  76    -9

I mean to say It must just compare the next field of a.dat only in such lines & get the result.Smilie

Last edited by reva; 12-09-2009 at 07:13 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging of all files based on a condition

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

How to compare 2 files & get specific value & replace it in other file.

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

Compare columns of 2 files based on condition defined in a different file

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

compare 2 files based on columns

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

compare 2 files and extract the data which is not present in other file with condition

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

moving files based on condition

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

compare 2 files and return unique lines in each file (based on condition)

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

Compare 2 csv files by columns, then extract certain columns of matcing rows

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

Compare between two files with condition

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

Compare two files with awk and condition

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
HTML::FormHandler::Manual(3pm)				User Contributed Perl Documentation			    HTML::FormHandler::Manual(3pm)

NAME
HTML::FormHandler::Manual - index of the manual VERSION
version 0.40013 DESCRIPTION
This is the HTML::FormHandler users manual. HTML::FormHandler is an HTML form handling class written in Moose. It provides facilities to write classes that represent HTML forms, and retrieves and loads data from the database. SECTIONS
HTML::FormHandler::Manual::Intro Creating FormHandler forms and interfacing them with your controllers. HTML::FormHandler::Manual::Fields Organized list of FormHandler fields, with links to specific documentation. HTML::FormHandler::Manual::Defaults Description of the various ways of setting defaults. HTML::FormHandler::Manual::InflationDeflation Inflation and deflation of fields HTML::FormHandler::Manual::Validation Validation of fields HTML::FormHandler::Manual::Errors Errors: setting them, getting them. HTML::FormHandler::Manual::Rendering Rendering options, particularly rendering with widgets HTML::FormHandler::Manual::Database Issues and setup for database forms. HTML::FormHandler::Manual::Tutorial Builds on the Catalyst tutorial. Step-by-step guide. HTML::FormHandler::Manual::Testing Test your forms HTML::FormHandler::Manual::Cookbook 'Howto' recipes HTML::FormHandler::Manual::Templates Cut-and-paste examples of templates to use with FormHandler HTML::FormHandler::Manual::Catalyst Catalyst specific documentation HTML::FormHandler::Manual::Reference Quick reference of FormHandler interface HTML::FormHandler::Manual::FromDFV Info on converting from Data::FormValidator HTML::FormHandler::Manual::FromFF Info on converting from HTML::FormFu SUPPORT
IRC: Join #formhandler on irc.perl.org Mailing list: http://groups.google.com/group/formhandler AUTHOR
gshank: Gerda Shank <gshank@cpan.org> AUTHOR
FormHandler Contributors - see HTML::FormHandler COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Gerda Shank. This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself. perl v5.14.2 2012-06-25 HTML::FormHandler::Manual(3pm)
All times are GMT -4. The time now is 11:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy