Minus of files


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Minus of files
# 1  
Old 10-23-2011
Minus of files

File 1 contains data :
Code:
CALL_ID
SOR_ID
SEG_SEQ_NUM
CHK_PNT_MENU_TYPE_CD
PTNR_ID
ACTVN_RTRN_CD
PRIM_ACTVN_DCLN_REAS_CD
SCNDRY_ACTVN_DCLN_REAS_CD
ACTVN_SCCS_IND
CARD_ACTVTD_IND
MAX_ACTVN_FAILD_ATMP_IND
EDW_PUBLN_ID

File 2 contains data:
Code:
PRIM_ACTVN_DCLN_REAS_CD
SCNDRY_ACTVN_DCLN_REAS_CD

I need the output file to contain the data in file 1 and not in file 2 as in:
Code:
CALL_ID
SOR_ID
SEG_SEQ_NUM
CHK_PNT_MENU_TYPE_CD
PTNR_ID
ACTVN_RTRN_CD
ACTVN_SCCS_IND
CARD_ACTVTD_IND
MAX_ACTVN_FAILD_ATMP_IND
EDW_PUBLN_ID

Thanks

Last edited by Franklin52; 10-24-2011 at 03:54 AM.. Reason: Please use code tags for data and code samples, thank you
# 2  
Old 10-23-2011
Code:
# one way ....
egrep -v -f <fileWithExcludes> <file with stuff>

# 3  
Old 10-23-2011
Code:
awk 'NR==FNR{a[$1]++;next} !a[$1]' file2 file1

# 4  
Old 10-24-2011
based on your input file ..
Code:
$ sdiff file1 file2 | nawk '/</ {print $1}'

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need to minus one day from a date given

Hello Folks, I have a variable output holding date as below - output = "20141220" I need to extract a day out of it and store it in another variable i.e. something similar to below - output1=20141219" and if the month is changing i.e. date in on 31st or 1st it should be taken care of "date... (5 Replies)
Discussion started by: ektubbe
5 Replies

2. Shell Programming and Scripting

How to get a time minus 60 minutes?

Hello, date --date '-60 min ago' +'%Y-%m-%d %H:%M:%S,%3N' Above command gives the date and time minus 60 minutes but the problem i am facing is, i do not want to hardcode the value 60 it is stored in a variable var=60 now if i run below command , i get error date --date '-$var min... (3 Replies)
Discussion started by: Ramneekgupta91
3 Replies

3. Shell Programming and Scripting

Date minus 1 day

Hi the below code is failing i am trying to generate do the following: 2014-10-22 11:26:00 (Substract 24 hrs) should produce 2014-10-21 11:26:00 I need the same formatting below because that gets inputted into code for an... (4 Replies)
Discussion started by: Samuel12
4 Replies

4. UNIX for Dummies Questions & Answers

Minus 5 minutes

Hi, I need to subtract 5 minutes from the date. Example $date +"%Y-%m-%d-%H.%M.%S" displays 2014-06-26-06.06.38 I want to show it as 2014-06-26-06.01.38 (5 mins are subtracted from date) Any help would be appreciated. I am currently on AIX version 6.1 -Vrushank (10 Replies)
Discussion started by: vrupatel
10 Replies

5. Shell Programming and Scripting

Minus minus to plus

Hi there, I have a problem with arithmetic ops in awk. Here is what my script does right now. while read nr val ; do case $nr in 400) awk '$2~/eigenvectors/ {print $NF-'$val'};' input.txt >> output.txt;; esac done < frames.txtI have a file named frames.txt with two columns (nr and... (2 Replies)
Discussion started by: tobias1234
2 Replies

6. Solaris

How to show time minus 60 minutes?

In Redhat it is easy.... date --date="60 minutes ago" How do you do this in Solaris? I got creative and got the epoch time but had problems.. EPOCHTIME=`truss date 2>&1 | grep "time()" | awk '{print $3 - 900}'` echo $EPOCHTIME TIME=`perl -e 'print scalar(localtime("$EPOCHTIME")),... (5 Replies)
Discussion started by: s ladd
5 Replies

7. UNIX for Dummies Questions & Answers

Rename file-name minus one?

I need to rename a directory full of files named like: page_001.jpg page_002.jpg page_003.jpg to the file name minus one. Meaning instead of page_001.jpg that file becomes page_000.jpg so: page_001.jpg => page_000.jpg page_002.jpg => page_001.jpg page_003.jpg => page_002.jpg I was... (3 Replies)
Discussion started by: RacerX
3 Replies

8. Shell Programming and Scripting

Minus of 2 files -- Please help

Hello people, awk '{print $0}' input1.txt input2.txt |sort -u Will give the union of the 2 files. Similarly what is command to get just the diff data (i.e minus) of the 2 files. Can I use the "diff" command to get just the diff data. Please let me know. Regards, Tipsy. (7 Replies)
Discussion started by: tipsy
7 Replies

9. UNIX for Dummies Questions & Answers

minus col1 and col2

my file looks like this: 101928 101943 101928 101944 101929 101943 101929 101943 101929 102044 i want to insert bc to get answer like this: 101928 101943 000015 101928 101944 000016 101929 101943 000013 101929 101943 000014 101929 102044 000115 total 000173 my... (3 Replies)
Discussion started by: tjmannonline
3 Replies

10. UNIX for Dummies Questions & Answers

minus sign

why a minus sign is put for options in unix commands suggestions plz (2 Replies)
Discussion started by: trichyselva
2 Replies
Login or Register to Ask a Question