Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Need unix commands to delete records from one file if the same record present in another file...
Top Forums Shell Programming and Scripting Need unix commands to delete records from one file if the same record present in another file... Post 302636189 by msathees on Monday 7th of May 2012 06:26:36 AM
Old 05-07-2012
tried with the below codes for getting the unmatched records... but the issue here is while loop will return unmatched records for every loop ... I need only a single output which it should contain only unmatched records

Code:
while read a ; do
  grep -v "^${a}$" a.file;
done < b.file

a.file --target file

b.file--- required records to be matched
Last edited by Scrutinizer; 05-07-2012 at 07:28 AM.. Reason: code tags
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to delete record in file data with index in another file?

I want to deal with several data, i.e., data.*.txt with following structure MSG|20010102|123 125 4562 409|SEND MSG|20010102|120 230|SEND MSG|20010102|120 204 5071|SEND MSG|20010103|2 11 1098 9810|SEND ...... index file index.txt is 11 201 298 100 ...... What I want to do is: 1)... (0 Replies)
Discussion started by: zhynxn
0 Replies

2. Shell Programming and Scripting

To find the count of records from tables present inside a file.

hi gurus, I am having a file containing a list of tables.i want to find the count of records inside thes tables. for this i have to connect into database and i have to put the count for all the tables inside another file i used the following loop once all the tablenames are inside the file. ... (1 Reply)
Discussion started by: navojit dutta
1 Replies

3. Shell Programming and Scripting

Delete Strings that are present in another file

HI, if a String is present in file1.txt, i want to delete that String from file2.txt. How can i do this?? I am sure that the file1.txt is a subset of file2.txt. (2 Replies)
Discussion started by: jathin12
2 Replies

4. Shell Programming and Scripting

converting all records of a file in to one record

I have a file temp.dat. The contents of this file is as follows abcdefgh abcdefgh abcdefgh abcdefgh abcdefgh abcdefgh The multiple records in this file needs to be converted in to a single record. abcdefgh abcdefgh abcdefgh abcdefgh abcdefgh abcdefgh (2 Replies)
Discussion started by: rsriramiyer
2 Replies

5. UNIX for Advanced & Expert Users

query display number lines or records present in file only numeric value -without filename

Hi all Thanks in advance........... Please help me for this issue............ I have a file it has 11 records . I used the command like .... >$ wc -l file 11 file I'm getting output like 11 file (no.of records along with filename) here my requirement is, I want to display only... (3 Replies)
Discussion started by: ksrivani
3 Replies

6. Shell Programming and Scripting

Delete a pattern present in file 2 from file 1 if found in file 1.

I have two files File1 ==== 1|2000-00-00|2010-02-02|| 2| 00:00:00|2012-02-24|| 3|2000-00-00|2011-02-02|| File2 ==== 2000-00-00 00:00:00 I want the delete the patterns which are found in file 2 from file 1, Expected output: File1 ==== (5 Replies)
Discussion started by: machomaddy
5 Replies

7. Shell Programming and Scripting

Delete records in mysql database where record is less than today

Guys, I need help. I need to create a script to delete records in mysql database where record is 2 days old. Thanks. (1 Reply)
Discussion started by: jasperux
1 Replies

8. Shell Programming and Scripting

Split a large file in n records and skip a particular record

Hello All, I have a large file, more than 50,000 lines, and I want to split it in even 5000 records. Which I can do using sed '1d;$d;' <filename> | awk 'NR%5000==1{x="F"++i;}{print > x}'Now I need to add one more condition that is not to break the file at 5000th record if the 5000th record... (20 Replies)
Discussion started by: ibmtech
20 Replies

9. Shell Programming and Scripting

Total record count of all the file present in a directory

Hi All , We need one help on the below requirement.We have multiple pipe delimited .txt file(around 100 .txt files) present on one directory.We need the total record count of all the files present in that directory without header.File format as below : ... (8 Replies)
Discussion started by: STCET22
8 Replies

10. UNIX for Advanced & Expert Users

Need help to delete special characters exists only at the end of the each record in UNIX file?

Hi, I have a file in unix with 15 columns.It consists special characters(#,$,^M,@,*,% etc)at the end of the each record.I want to remove these special characters.I used the following: Sed -e 's/ /g;s/ */ /g' . But It is removing special characters exists everywhere in the file(begining,middle... (24 Replies)
Discussion started by: rakeshp
24 Replies

LEARN ABOUT DEBIAN

eurephiadm-attempts

eurephiadm attempts(7)													    eurephiadm attempts(7)

NAME

       eurephiadm-attempts - Manage the attempts log in eurephia

DESCRIPTION

       When a remote user fails to authenticate correctly, the attemp will be logged.  After a certain amount of attempts the IP address, certifi-
       cate and/or user account will be blocked.  The eurephiadm attempts command is used to get an overview over what	is  registered	as  failed
       attempts and to give the possibility to reset or delete the registered attempts counter.

       Available modes for the attempts command are:

       -D | --delete
	      Delete a registered login attempt

       -R | --reset
	      Reset a registered login attempt

       -l | --list
	      List all registered login attempts

       -h | --help <mode>
	      Show help

DELETE MODE

       The attempts delete mode will remove a record from the attempts log.

   One of the following parameters must be given (only one):
       -u | --username <username>
	      User name to delete

       -d | --digest <SHA1 digest>
	      Certificate SHA1 digest to delete

       -i | --ipaddr <IP address>
	      IP address to delete

       -a | --attemptid <ID>
	      Attempts record ID to delete

RESET MODE

       The attempts reset mode will reset the attempt counter.

   One of the following parameters must be given (only one):
       -u | --username <username>
	      User name to reset

       -d | --digest <SHA1 digest>
	      Certificate SHA1 digest to reset

       -i | --ipaddr <IP address>
	      IP address to reset

       -a | --attemptid <ID>
	      Attempts record ID to reset

LIST MODE

       The attempts list mode will show all registered login attempts.

       -v | --verbose
	      Show more details

   Filters:
       -u | --username <username>
	      List only attempts matching the given user name

       -d | --digest <SHA1 digest>
	      List only attempts matching the given SHA1 certificate digest

       -i | --ipaddr <IP address>
	      List only attempts matching the given IP address

SEE ALSO

       eurephiadm-blacklist(7), eurephia-config(7)

AUTHOR

       Copyright (C) 2008-2010	David Sommerseth <dazo@users.sourceforge.net>

David Sommerseth						     July 2010						    eurephiadm attempts(7)
All times are GMT -4. The time now is 11:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy