How to compare 2 files & get only few columns based on a condition related to both files? Post: 302378863

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:...

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 ...

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...

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...

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

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 ##...

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...

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'...

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...

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)...

LEARN ABOUT DEBIAN

sdpa

SDPA(1) 						      General Commands Manual							   SDPA(1)

NAME

       SDPA - High-performance software package for SemiDefinite Programs

SYNOPSIS

       sdpa DataFile OutputFile [InitialPtFile] [-pt parameters] [-dimacs] [-numThreads  numThreads]
       sdpa [options] files...
       sdpa --version

DESCRIPTION

       sdpa  - "SDPA (SemiDefinite Programming Algorithm)" is one of the most efficient and stable software packages for solving SDPs based on the
       primal-dual interior-point method.

       SDP (SemiDefinite Program) is used for financial engineering, machine learning, control theory, sensor network problem, quantum	chemistry,
       quantum information, combinatorial optimizaiton, polynomial optimization, and so on.

       Futher information on SDP and SDPA can be found at
       http://sdpa.sourceforge.net/

OPTIONS

       ---- option type 1 ----
       sdpa DataFile OutputFile [InitialPtFile] [-pt parameters] [-dimacs] [-numThreads numThreads]
       parameters = 0 default, 1 fast (unstable), 2 slow (stable)
       example1-1: sdpa example1.dat example1.result
       example1-2: sdpa example1.dat-s example1.result
       example1-3: sdpa example1.dat example1.result example1.ini
       example1-4: sdpa example1.dat example1.result -pt 2
       example1-5: sdpa example1.dat example1.result -dimacs
       example1-6: sdpa example1.dat example1.result -numThreads 4
       ---- option type 2 ----
       sdpa [option filename]+
	 -dd : data dense :: -ds : data sparse
	 -id : init dense :: -is : init sparse
	 -o  : output	  :: -p  : parameter
	 -pt : parameters , 0 default, 1 fast (unstable)
			    2 slow (stable)
       example2-1: sdpa -o example1.result -dd example1.dat
       example2-2: sdpa -ds example1.dat-s -o example1.result -p param.sdpa
       example2-3: sdpa -ds example1.dat-s -o example1.result -pt 2
       example2-4: sdpa -ds example1.dat-s -o example1.result -dimacs
       example2-5: sdpa -ds example1.dat-s -o example1.result -numThreads 4
       ---- option type 3 ----
       sdpa --version
       to print out version and exit.

       PARAMETER_FILE
	      is decided by the following priority
		 1: The file assigned by '-p' option of 'option type 2'.
		     For 'option type1', this is skipped.
		 2: ./param.sdpa
		     For 'option type2', this is skipped.
		 3: /usr/share/sdpa/param.sdpa
		 4: Default parameter

       -dimacs
	      printout dimacs information incurring additional computation cost

       -numThreads
	      number of pthreads for internal computation

AUTHOR

       SDPA was written by SDPA Project <sdpa-developers@lists.sourceforge.net>.

       This manual page was written by Makoto Yamashita <Makoto.Yamashita@is.titech.ac.jp>.

								   July 28, 2011							   SDPA(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Merging of all files based on a condition

Discussion started by: arund_01

2. UNIX for Dummies Questions & Answers

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

Discussion started by: reva

3. Shell Programming and Scripting

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

Discussion started by: newtoawk

4. Shell Programming and Scripting

compare 2 files based on columns

Discussion started by: novice_man