Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: compare 2 files
Top Forums Shell Programming and Scripting compare 2 files Post 302449233 by ygemici on Sunday 29th of August 2010 03:31:46 PM
Old 08-29-2010
MySQL
for first case
Code:
# for i in $(sed "" file2)
  do 
   sed -ne "/$i/N;s/^\([^ ]*\) *\([^ ]*\).*\n[^ ]*\( *[^ ]*\).*$/\1 = \2, \3/p" file1
    if [[ $(sed -n "/$i/p" file1) == "" ]] ; then 
      sed -n "/$i/s/.*/$i = do not have segy/p" file2
    fi 
  done
 
s02s-04 = mig_ver03_dtr,   pstm_ver03_dtr
s02s-05 = mig_ver03_dtr,    pstm_ver03_dtr
s02s-06 = do not have segy
s02s-07 = do not have segy
s02s-08 = do not have segy
s02s-09 = do not have segy

for second case
Code:
# ./justdoit
        xxxxx 1015
    6   1580
   36   1645
   66   1730
   96   1815
  126   1900
  156   1979
  186   2022
  216   2047
  246   2073
  276   2098
        xxxxx 1035
  216   2011
  246   2051
  276   2090
  306   2130
  336   2167
  366   2191
  396   2210
  426   2229
  456   2249
        xxxxx 1055
    6   1628
   36   1636
   66   1688
   96   1758
  126   1828
  156   1898
  186   1954
  216   1988
  246   2021
  276   2053
  306   2085
  336   2116

Code:
 ## justdoit ##
#!/bin/bash
sedarray=( $(sed -e '$d' -e 's/^\([^ ]*\).*/\1/;N;N;N;N;N;N;N;N;N' -e 's/^\([^ ]*\).*\n\1.*/\1/'  infile) )
for ((i=0;i<${#sedarray[@]};i++))
 do
  sed -n "/${sedarray[i]}/,/${sedarray[i+1]}/{;/${sedarray[i+1]}/!p}" infile | sed -e 's/^[^ ]*//' | sed '1i \\txxxxx '${sedarray[i]}' '
 done
  sed -n '/'${sedarray[i-1]}'/,/$/{p}' infile | sed -e 's/^[^ ]*//' | sed '1i \\txxxxx '${sedarray[i-1]}' '

This User Gave Thanks to ygemici For This Post:
ipatah
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

compare two files

I have file1 and file2: file1: 11 xxx kksd ... 22 kkk kdsglg... 33 sss kdfjdksa... 44 kdsf dskjfkas ... hh kdkf kdkkd.. jg dkf dfkdk ... ... file2: jg 22 hh ... I need to check each line of file1. if the field one is in file2, I will keep it; if not, the whole line will be... (17 Replies)
Discussion started by: fredao
17 Replies

2. Shell Programming and Scripting

compare two files and to remove the matching lines on both the files

I have two files and need to compare the two files and to remove the matching lines from both the files (4 Replies)
Discussion started by: shellscripter
4 Replies

3. Shell Programming and Scripting

compare files in two directories and output changed files to third directory

I have searched about 30 threads, a load of Google pages and cannot find what I am looking for. I have some of the parts but not the whole. I cannot seem to get the puzzle fit together. I have three folders, two of which contain different versions of multiple files, dist/file1.php dist/file2.php... (4 Replies)
Discussion started by: bkeep
4 Replies

4. Shell Programming and Scripting

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

Hiiiii friends I have 2 files which contains huge data & few lines of it are as shown below File1: b.dat(which has 21 columns) SSR 1976 8 12 13 10 44.00 39.0700 70.7800 7.0 0 0.00 0 2.78 0.00 0.00 0 0.00 2.78 0 NULL ISC 1976 8 12 22 32 37.39 36.2942 70.7338... (6 Replies)
Discussion started by: reva
6 Replies

5. Shell Programming and Scripting

Compare 2 folders to find several missing files among huge amounts of files.

Hi, all: I've got two folders, say, "folder1" and "folder2". Under each, there are thousands of files. It's quite obvious that there are some files missing in each. I just would like to find them. I believe this can be done by "diff" command. However, if I change the above question a... (1 Reply)
Discussion started by: jiapei100
1 Replies

6. Shell Programming and Scripting

Require compare command to compare 4 files

I have four files, I need to compare these files together. As such i know "sdiff and comm" commands but these commands compare 2 files together. If I use sdiff command then i have to compare each file with other which will increase the codes. Please suggest if you know some commands whcih can... (6 Replies)
Discussion started by: nehashine
6 Replies

7. Shell Programming and Scripting

Compare files

Please help me with awk.I have two files with the below details file1 123456789 2012 987654321 2011 a1234567892012 a1234abcde2012 b1234567892012 c1234567892012 98765a12342012 file2 a1234 01234 b1234 33333 I need to check whether the items in file2 is present in file1 .If it is... (2 Replies)
Discussion started by: Mary James
2 Replies

8. Shell Programming and Scripting

Compare two files, then overwrite first file with only that in both files

I want to compare two files, and search for items that are in both. Then override the first file with that containing only elements which were in both files. I imagine something with diff, but not sure. File 1 One Two Three Four Five File 2 One Three Four Six Eight (2 Replies)
Discussion started by: castrojc
2 Replies

9. Shell Programming and Scripting

Compare multiple files, and extract items that are common to ALL files only

I have this code awk 'NR==FNR{a=$1;next} a' file1 file2 which does what I need it to do, but for only two files. I want to make it so that I can have multiple files (for example 30) and the code will return only the items that are in every single one of those files and ignore the ones... (7 Replies)
Discussion started by: castrojc
7 Replies

10. Shell Programming and Scripting

Compare files and share output from both files

hi all, Thanks to all for your great help... I have a scenario that I have two files (file1 & file2). I need to compare two files entire row by row and share the output if any discrepancies within two files. File1: DB1|TB1|C1,C3 DB2|TB2|C1,C2 DB3|TB3|C1,C2,C3,C4 File2: ... (2 Replies)
Discussion started by: Selva_2507
2 Replies

LEARN ABOUT SUNOS

iconv_852

iconv_852(5)						Standards, Environments, and Macros					      iconv_852(5)

NAME

       iconv_852 - code set conversion tables for MS 852 (MS-DOS Latin 2)

DESCRIPTION

       The following code set conversions are supported:

       +--------------------------------------------------------------------+
       |		  Code Set Conversions Supported		    |
       +--------------+--------+--------------+--------+--------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |   Target Output    |
       +--------------+--------+--------------+--------+--------------------+
       |MS 852	      |dos2    |ISO 8859-2    |iso2    | ISO Latin 2	    |
       +--------------+--------+--------------+--------+--------------------+
       |MS 852	      |dos2    |MS 1250       |win2    | Windows Latin 2    |
       +--------------+--------+--------------+--------+--------------------+
       |MS 852	      |dos2    |Mazovia       |maz     | Mazovia	    |
       +--------------+--------+--------------+--------+--------------------+
       |MS 852	      |dos2    |DHN	      |dhn     | Dom Handlowy Nauki |
       +--------------+--------+--------------+--------+--------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   MS 852 to ISO 8859-2
       For the conversion of MS 852 to ISO 8859-2, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |    MS 852     |  ISO 8859-2	|    MS 852	 |  ISO 8859-2	 |
       |24-177	       | 40		|271-274	 |40		 |
       |200	       | 307		|275		 |257		 |
       |201	       | 374		|276		 |277		 |
       |202	       | 351		|277-305	 |40		 |
       |203	       | 342		|306		 |303		 |
       |204	       | 344		|307		 |343		 |
       |205	       | 371		|310-316	 |40		 |
       |206	       | 346		|317		 |244		 |
       |207	       | 347		|320		 |360		 |
       |210	       | 263		|321		 |320		 |
       |211	       | 353		|322		 |317		 |
       |212	       | 325		|323		 |313		 |
       |213	       | 365		|324		 |357		 |
       |214	       | 356		|325		 |322		 |
       |215	       | 254		|326		 |315		 |
       |216	       | 304		|327		 |316		 |
       |217	       | 306		|330		 |354		 |
       |220	       | 311		|331-334	 |40		 |
       |221	       | 305		|335		 |336		 |
       |222	       | 345		|336		 |331		 |
       |223	       | 364		|337		 |40		 |
       |224	       | 366		|340		 |323		 |
       |225	       | 245		|341		 |337		 |
       |226	       | 265		|342		 |324		 |
       |227	       | 246		|343		 |321		 |
       |230	       | 266		|344		 |361		 |
       |231	       | 326		|345		 |362		 |
       |232	       | 334		|346		 |251		 |
       |233	       | 253		|347		 |271		 |
       |234	       | 273		|350		 |300		 |
       |235	       | 243		|351		 |332		 |
       |236	       | 327		|352		 |340		 |
       |237	       | 350		|353		 |333		 |
       |240	       | 341		|354		 |375		 |
       |241	       | 355		|355		 |335		 |
       |242	       | 363		|356		 |376		 |
       |243	       | 372		|357		 |264		 |
       |244	       | 241		|360		 |255		 |
       |245	       | 261		|361		 |275		 |
       |246	       | 256		|362		 |262		 |
       |247	       | 276		|363		 |267		 |
       |250	       | 312		|364		 |242		 |
       |251	       | 352		|365		 |247		 |
       |252	       | 40		|366		 |367		 |
       |253	       | 274		|367		 |270		 |
       |254	       | 310		|370		 |260		 |
       |255	       | 272		|371		 |250		 |
       |256-264        | 40		|372		 |377		 |
       |265	       | 301		|374		 |330		 |
       |266	       | 302		|375		 |370		 |
       |267	       | 314		|376		 |40		 |
       |270	       | 252		|		 |		 |
       +---------------+----------------+----------------+---------------+

   MS 852 to MS 1250
       For the conversion of MS 852 to MS 1250, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |    MS 852     |    MS 1250	|    MS 852	 |   MS 1250	 |
       |200	       | 307		|270		 |252		 |
       |201	       | 374		|271-274	 |40		 |
       |202	       | 351		|275		 |257		 |
       |203	       | 342		|276		 |277		 |
       |204	       | 344		|277-305	 |40		 |
       |205	       | 371		|306		 |303		 |
       |206	       | 346		|307		 |343		 |
       |207	       | 347		|310-316	 |40		 |
       |210	       | 263		|317		 |244		 |
       |211	       | 353		|320		 |360		 |
       |212	       | 325		|321		 |320		 |
       |213	       | 365		|322		 |317		 |
       |214	       | 356		|323		 |313		 |
       |215	       | 217		|324		 |357		 |
       |216	       | 304		|325		 |322		 |
       |217	       | 306		|326		 |315		 |
       |220	       | 311		|327		 |316		 |
       |221	       | 305		|330		 |354		 |
       |222	       | 345		|331-334	 |40		 |
       |223	       | 364		|335		 |336		 |
       |224	       | 366		|336		 |331		 |
       |225	       | 274		|337		 |40		 |
       |226	       | 276		|340		 |323		 |
       |227	       | 214		|341		 |337		 |
       |230	       | 234		|342		 |324		 |
       |231	       | 326		|343		 |321		 |
       |232	       | 334		|344		 |361		 |
       |233	       | 215		|345		 |362		 |
       |234	       | 235		|346		 |212		 |
       |235	       | 243		|347		 |232		 |
       |236	       | 327		|350		 |300		 |
       |237	       | 350		|351		 |332		 |
       |240	       | 341		|352		 |340		 |
       |241	       | 355		|353		 |333		 |
       |242	       | 363		|354		 |375		 |
       |243	       | 372		|355		 |335		 |
       |244	       | 245		|356		 |376		 |
       |245	       | 271		|357		 |264		 |
       |246	       | 216		|360		 |255		 |
       |247	       | 236		|361		 |275		 |
       |250	       | 312		|362		 |262		 |
       |251	       | 352		|363		 |241		 |
       |252	       | 254		|364		 |242		 |
       |253	       | 237		|365		 |247		 |
       |254	       | 310		|366		 |367		 |
       |255	       | 272		|367		 |270		 |
       |256	       | 253		|370		 |260		 |
       |257	       | 273		|371		 |250		 |
       |260-264        | 40		|372		 |377		 |
       |265	       | 301		|374		 |330		 |
       |266	       | 302		|375		 |370		 |
       |267	       | 314		|376		 |40		 |
       +---------------+----------------+----------------+---------------+

   MS 852 to Mazovia
       For the conversion of MS 852 to Mazovia, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |    MS 852     |    Mazovia	|    MS 852	 |   Mazovia	 |
       |205	       | 40		|246-247	 |40		 |
       |206	       | 215		|250		 |220		 |
       |210	       | 222		|251		 |221		 |
       |212-213        | 40		|253		 |246		 |
       |215	       | 240		|254-270	 |40		 |
       |217	       | 225		|275		 |241		 |
       |220-226        | 40		|276		 |247		 |
       |227	       | 230		|306-336	 |40		 |
       |230	       | 236		|340		 |243		 |
       |233-234        | 40		|342		 |40		 |
       |235	       | 234		|343		 |245		 |
       |236-243        | 40		|344		 |244		 |
       |244	       | 217		|345-375	 |40		 |
       |245	       | 206		|		 |		 |
       +---------------+----------------+----------------+---------------+

   MS 852 to DHN
       For the conversion of MS 852 to DHN, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |    MS 852     |      DHN	|    MS 852	 |     DHN	 |
       |200-205        | 40		|244		 |200		 |
       |206	       | 212		|245		 |211		 |
       |207	       | 40		|246-247	 |40		 |
       |210	       | 214		|250		 |202		 |
       |211-214        | 40		|251		 |213		 |
       |215	       | 207		|253		 |220		 |
       |216	       | 40		|254-270	 |40		 |
       |217	       | 201		|275		 |210		 |
       |220-226        | 40		|276		 |221		 |
       |227	       | 206		|306-336	 |40		 |
       |230	       | 217		|340		 |205		 |
       |233-234        | 40		|342		 |40		 |
       |235	       | 203		|343		 |204		 |
       |236-237        | 40		|344		 |215		 |
       |242	       | 216		|345-375	 |40		 |
       |252	       | 254		|		 |		 |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so	       conversion modules

       /usr/lib/iconv/*.t	       conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10							    18 Apr 1997 						      iconv_852(5)
All times are GMT -4. The time now is 12:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy