Sponsored Content
Top Forums Shell Programming and Scripting awk to compare flat files and print output to another file Post 302432576 by methyl on Friday 25th of June 2010 11:04:06 AM
Old 06-25-2010
The database approach is winning because of the requirement to retain the original random order and to get enough speed to check each record in turn. Can't see an obvious way to keep any other form of compare in step when there is such a high volume of differences.

1) Load each external flat file into a separate table, using the whole record as the key.
2) Re-read each external flat file in turn checking the result of a seek of each record in the opposing file, outputting non-matches to a respective further external file.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to compare lines of two files and print output on screen

hey guys, I have two files both with two columns, I have already created an awk code to ignore certain lines (e.g lines that start with 963) as they wou ld begin with a certain string, however, the rest I have added together and calculated the average. At the moment the code also displays... (3 Replies)
Discussion started by: chlfc
3 Replies

2. Shell Programming and Scripting

compare columns from seven files and print the output

Hi guys, I need some help to come out with a solution . I have seven such files but I am showing only three for convenience. filea a5 20 a8 16 fileb a3 42 a7 14 filec a5 23 a3 07 The output file shoud contain the data in table form showing first field of... (7 Replies)
Discussion started by: smriti_shridhar
7 Replies

3. Shell Programming and Scripting

compare two files and search keyword and print output

You have two files to compare by searching keyword from one file into another file File A 23 >pp_ANSWER 24 >aa hello 25 >jau head wear 66 >jss oops 872 >aqq olps ploww oww sss 722 >GG_KILLER ..... large files File B Beta done KILLER John Mayor calix meyers ... (5 Replies)
Discussion started by: cdfd123
5 Replies

4. UNIX for Advanced & Expert Users

Shell Script to compare xml files and print output to a file

All, PLease can you help me with a shell script which can compare two xml files and print the difference to a output file. I have attached one such file for you reference. <Group> <Member ID=":Year_Quad:41501" childCount="4" fullPath="PEPSICO Year-Quad-Wk : FOLDER.52 Weeks Ending Dec... (2 Replies)
Discussion started by: kanthrajgowda
2 Replies

5. Shell Programming and Scripting

awk compare specific columns from 2 files, print new file

Hello. I have two files. FILE1 was extracted from FILE2 and modified thanks to help from this post. Now I need to replace the extracted, modified lines into the original file (FILE2) to produce the FILE3. FILE1 1466 55.27433 14.72050 -2.52E+03 3.00E-01 1.05E+04 2.57E+04 1467 55.27433... (1 Reply)
Discussion started by: jm4smtddd
1 Replies

6. Shell Programming and Scripting

Compare two files and print using awk

I have 2 files: email_1.out 1 abc@yahoo.com 2 abc_1@yahoo.com 3 abc_2@yahoo.com data_1.out <tr> 1 MAIL # 1 TO src_1 </tr> <tr><td class="hcol">col_id</td> <td class="hcol">test_dt</td> <td class="hcol">user_type</td> <td class="hcol">ct</td></tr> <tr><td... (1 Reply)
Discussion started by: sol_nov
1 Replies

7. Shell Programming and Scripting

Compare to flat files using awk

compare to flat files using awk .but in 4th field contains non ordered substring. how to do that. file1.txt john|0.0|4|**:25;JP:50;UY:25 file2.txt andy|0.0|4|JP:50;**:25;UY:25 (4 Replies)
Discussion started by: veeruasu
4 Replies

8. Shell Programming and Scripting

Compare columns of multiple files and print those unique string from File1 in an output file.

Hi, I have multiple files that each contain one column of strings: File1: 123abc 456def 789ghi File2: 123abc 456def 891jkl File3: 234mno 123abc 456def In total I have 25 of these type of file. (5 Replies)
Discussion started by: owwow14
5 Replies

9. Shell Programming and Scripting

[Solved] awk compare two different columns of two files and print all from both file

Hi, I want to compare two columns from file1 with another two column of file2 and print matched and unmatched column like this File1 1 rs1 abc 3 rs4 xyz 1 rs3 stu File2 1 kkk rs1 AA 10 1 aaa rs2 DD 20 1 ccc ... (2 Replies)
Discussion started by: justinjj
2 Replies

10. UNIX for Beginners Questions & Answers

Compare two files and print output

Hi All, i am trying to compare two files in Centos 6. F1: /tmp/d21 NAME="xvda" TYPE="disk" SIZE="40G" OWNER="root" GROUP="disk" MODE="brw-rw----" MOUNTPOINT="" NAME="xvda1" TYPE="part" SIZE="500M" OWNER="root" GROUP="disk" MODE="brw-rw----" MOUNTPOINT="/boot" NAME="xvda2" TYPE="part"... (2 Replies)
Discussion started by: balu1234
2 Replies
wxMouseEvent(3erl)					     Erlang Module Definition						wxMouseEvent(3erl)

NAME
wxMouseEvent - See external documentation: wxMouseEvent. DESCRIPTION
See external documentation: wxMouseEvent . Use wxEvtHandler:connect/3 with EventType: : left_down , left_up , middle_down , middle_up , right_down , right_up , motion , enter_window , leave_window , left_dclick , mid- dle_dclick , right_dclick , mousewheel , nc_left_down , nc_left_up , nc_middle_down , nc_middle_up , nc_right_down , nc_right_up , nc_motion , nc_enter_window , nc_leave_window , nc_left_dclick , nc_middle_dclick , nc_right_dclick See also the message variant #wxMouse{ } event record type. This class is derived (and can use functions) from: wxEvent DATA TYPES
wxMouseEvent() : An object reference, The representation is internal and can be changed without notice. It can't be used for comparsion stored on disc or distributed for use on other nodes. EXPORTS
altDown(This::wxMouseEvent()) -> bool() See external documentation . button(This::wxMouseEvent(), But::integer()) -> bool() See external documentation . buttonDClick(This::wxMouseEvent()) -> bool() Equivalent to buttonDClick(This, []) . buttonDClick(This::wxMouseEvent(), Options::[Option]) -> bool() Types Option = {but, integer()} See external documentation . buttonDown(This::wxMouseEvent()) -> bool() Equivalent to buttonDown(This, []) . buttonDown(This::wxMouseEvent(), Options::[Option]) -> bool() Types Option = {but, integer()} See external documentation . buttonUp(This::wxMouseEvent()) -> bool() Equivalent to buttonUp(This, []) . buttonUp(This::wxMouseEvent(), Options::[Option]) -> bool() Types Option = {but, integer()} See external documentation . cmdDown(This::wxMouseEvent()) -> bool() See external documentation . controlDown(This::wxMouseEvent()) -> bool() See external documentation . dragging(This::wxMouseEvent()) -> bool() See external documentation . entering(This::wxMouseEvent()) -> bool() See external documentation . getButton(This::wxMouseEvent()) -> integer() See external documentation . getPosition(This::wxMouseEvent()) -> {X::integer(), Y::integer()} See external documentation . getLogicalPosition(This::wxMouseEvent(), Dc::wxDC() (see module wxDC)) -> {X::integer(), Y::integer()} See external documentation . getLinesPerAction(This::wxMouseEvent()) -> integer() See external documentation . getWheelRotation(This::wxMouseEvent()) -> integer() See external documentation . getWheelDelta(This::wxMouseEvent()) -> integer() See external documentation . getX(This::wxMouseEvent()) -> integer() See external documentation . getY(This::wxMouseEvent()) -> integer() See external documentation . isButton(This::wxMouseEvent()) -> bool() See external documentation . isPageScroll(This::wxMouseEvent()) -> bool() See external documentation . leaving(This::wxMouseEvent()) -> bool() See external documentation . leftDClick(This::wxMouseEvent()) -> bool() See external documentation . leftDown(This::wxMouseEvent()) -> bool() See external documentation . leftIsDown(This::wxMouseEvent()) -> bool() See external documentation . leftUp(This::wxMouseEvent()) -> bool() See external documentation . metaDown(This::wxMouseEvent()) -> bool() See external documentation . middleDClick(This::wxMouseEvent()) -> bool() See external documentation . middleDown(This::wxMouseEvent()) -> bool() See external documentation . middleIsDown(This::wxMouseEvent()) -> bool() See external documentation . middleUp(This::wxMouseEvent()) -> bool() See external documentation . moving(This::wxMouseEvent()) -> bool() See external documentation . rightDClick(This::wxMouseEvent()) -> bool() See external documentation . rightDown(This::wxMouseEvent()) -> bool() See external documentation . rightIsDown(This::wxMouseEvent()) -> bool() See external documentation . rightUp(This::wxMouseEvent()) -> bool() See external documentation . shiftDown(This::wxMouseEvent()) -> bool() See external documentation . AUTHORS
<> wxErlang 0.98.9 wxMouseEvent(3erl)
All times are GMT -4. The time now is 02:47 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy