Sponsored Content
Top Forums Shell Programming and Scripting open 2 files and compare values script - urgent Post 302436645 by inkyponky on Monday 12th of July 2010 06:10:44 PM
Old 07-12-2010
open 2 files and compare values script - urgent

Hi gurus

I have two csv files that are outputs. The file contains data similar to
Code:
s.no,number1,number2,date1  
--------------------------------
1, a123,482.29,11/28/07 13:00 
2,a124,602.7,9/24/07 14:00
3,a125,266.93,10/9/07 16.48
4,a126,785.15,11/14/07 16:08

<file 2>

Code:
s.no name date2 number1 bincode
-------------------------------------
1, el,  9/13/07,  a124,1
2,mg,12/1/06,a125,1
3,wh,3/7/07,a123,0
4,mr,11/24/06,a126,null

The script is to open these two files, compare if date1 is before (earlier) than 10/23/07 and if yes then bincode in file 2 should have 1. If not 1 or incorrectly set to 0 then print it in file3 called report. if date is later then have null or 0 value.

How to do this...

Last edited by vgersh99; 07-12-2010 at 07:16 PM.. Reason: code tags, please!
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare values between files

I have two files with same name residing in different directory. Each file has 14 columns. I want to compare column by column for each row. Also, have to take two columns as key identifier;pick a row in File1; retrieve the corresponding row from file2 and then compare the values. Can... (1 Reply)
Discussion started by: Sangtha
1 Replies

2. Shell Programming and Scripting

Need to compare values on two CSV files

:( Hello, Having a problem with reading two files using awk/nawk, am new to both them. I need to compare field values between two csv files and arrange for an appropriate output if both the values are equal or not for each feild. $cat File1.csv... (4 Replies)
Discussion started by: pgop
4 Replies

3. Shell Programming and Scripting

Help with script to open and compare csv files

We are testing an application that accesses two tables: A and B. I am to write a script to validate the ouput files of this application.The application marks any account that has become overdue as per rule. When it runs, it updates the overdue flag in the A table according to the following rules: ... (1 Reply)
Discussion started by: inkyponky
1 Replies

4. Shell Programming and Scripting

Compare two files based on values of fields.

Hi All, I have two files and data looks like this: File1 Contents #Field1,Field2 Dist_Center_file1.txt;21 Dist_Center_file3.txt;20 Dist_Center_file2.txt;20 File2 Contents (*** No Header ***) Dist_Center_file1.txt;23 Dist_Center_file2.txt;20 Dist_Center_file3.txt;20 I have... (4 Replies)
Discussion started by: Hangman2
4 Replies

5. Shell Programming and Scripting

Compare to files and export only different values

Hello, I need to compare two files which have the following structure File1: No : 1 Name : George/Brown Value2 : type2 Value3 : type3 Date : Wed Oct 20 11:12:58 2010 Value : yes No : 2 Name : John/Cash Value2 :... (4 Replies)
Discussion started by: @dagio
4 Replies

6. Shell Programming and Scripting

Compare values in two files. For matching rows print corresponding values from File 1 in File2.

- I have two files (File 1 and File 2) and the contents of the files are mentioned below. - I am trying to compare the values of Column1 of File1 with Column1 of File2. If a match is found, print the corresponding value from Column2 of File1 in Column5 of File2. - I tried to modify and use... (10 Replies)
Discussion started by: Santoshbn
10 Replies

7. Shell Programming and Scripting

LINUX - How to compare the values in 2 files & exit from the script

Hi All, I have a requirement where I need to compare 2 files & if the values in the files match, it should proceed, else exit the script without proceeding further. For e.g : Scenario 1 In this case, the script should exit without proceeding further. Scenario 2 In this case, the script... (7 Replies)
Discussion started by: dsfreddie
7 Replies

8. Shell Programming and Scripting

Find and compare values from different txt files

Hello, i am new in Bash. Actually i have a directory : /home/resultfiles and inside i have these txt files: 531_1.out.res, 531_2.out.res , 531_3.out.res 532_1.out.res, 532_2.out.res , 532_3.out.res 533_1.out.res, 533_2.out.res, 533_3.out.res All these txt files has this format : num_q all... (3 Replies)
Discussion started by: nimpoura
3 Replies

9. Shell Programming and Scripting

Compare two files column values using awk

Judi # cat File1 judi /export/home 76 judi /usr 83 judi # judi # cat File2 judi /export/home 79 judi /usr 82 judi # if COLUMN3 of File2 is greater that COLUMN3 of File1, then print File2's lines juid /export/home 79 Code tags please (2 Replies)
Discussion started by: judi
2 Replies

10. Shell Programming and Scripting

Compare values in two different files

Hello, I have output in one file that looks like: AA 3 BB 1 CC 3 DD 6 EE 2 FF 6 And output in another file that looks like: 1 EE 3 CC 2 AA I basically want to be able to match the counts in each file against the correct corresponding initials (and then obviosuly base a command on... (7 Replies)
Discussion started by: Nik44
7 Replies
t_look(3)						     Library Functions Manual							 t_look(3)

NAME
t_look() - look at the current event on a transport endpoint SYNOPSIS
DESCRIPTION
The function returns the current event on the transport endpoint specified by fd. This function enables a transport provider to notify a transport user of an asynchronous event when the user is calling functions in synchronous mode. Certain events require immediate notifica- tion of the user and are indicated by a specific error, [TLOOK], on the current or next function to be executed. This function also enables a transport user to poll a transport endpoint periodically for asynchronous events. Valid States All - apart from XTI Internet Protocol-specific Information As soon as a segment with the TCP urgent pointer set enters the TCP receive buffer, the event is indicated. remains set until all data up to the byte pointed to by the TCP urgent pointer has been received. If the urgent pointer is updated, and the user has not yet received the byte previously pointed to by the urgent pointer, the update is transparent to the user. Fork Safety is not fork-safe. RETURN VALUE
Upon success, returns a value that indicates which of the following allowable events has occurred, or returns zero if no event exists. One of the following events is returned: T_LISTEN connection indication received. T_CONNECT connect confirmation received. T_DATA normal data received. T_ERROR (TLI ONLY) fatal error occurred. T_EXDATA expedited data received. T_DISCONNECT disconnect received. T_UDERR datagram error indication. T_ORDREL orderly release indication. T_GODATA (XTI only) flow control restrictions on normal data flow have been lifted. Normal data may be sent again. T_GOEXDATA (XTI only) flow control restrictions on expedited data flow have been lifted. Expedited data may be sent again. ERRORS
On failure, is set to one of the following: [TBADF] The specified identifier does not refer to a transport endpoint. [TSYSERR] A system error has occurred during execution of this function. [TPROTO] (XTI only) This error indicates that a communication problem has been detected between XTI and the transport provider for which there is no suitable XTI ( SEE ALSO
t_open(3), t_snd(3), t_sndudata(3), thread_safety(5). STANDARDS CONFORMANCE
t_look(3)
All times are GMT -4. The time now is 08:46 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy