Need unix commands to delete records from one file if the same record present in another file... Post: 302636203

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)...

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. ...

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.

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

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...

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 ====

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.

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...

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 : ...

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...

LEARN ABOUT OSX

tdbtool

TDBTOOL(8)																TDBTOOL(8)

NAME

       tdbtool - manipulate the contents TDB files

SYNOPSIS

       tdbtool

       tdbtool TDBFILE [COMMANDS...]

DESCRIPTION

       This tool is part of the samba(1) suite.

       tdbtool	a  tool  for  displaying and altering the contents of Samba TDB (Trivial DataBase) files. Each of the commands listed below can be
       entered interactively or provided on the command line.

COMMANDS

       create TDBFILE
	  Create a new database named TDBFILE.

       open TDBFILE
	  Open an existing database named TDBFILE.

       erase
	  Erase the current database.

       dump
	  Dump the current database as strings.

       cdump
	  Dump the current database as connection records.

       keys
	  Dump the current database keys as strings.

       hexkeys
	  Dump the current database keys as hex values.

       info
	  Print summary information about the current database.

       insert KEY DATA
	  Insert a record into the current database.

       move KEY TDBFILE
	  Move a record from the current database into TDBFILE.

       store KEY DATA
	  Store (replace) a record in the current database.

       show KEY
	  Show a record by key.

       delete KEY
	  Delete a record by key.

       list
	  Print the current database hash table and free list.

       free
	  Print the current database and free list.

       ! COMMAND
	  Execute the given system command.

       first
	  Print the first record in the current database.

       next
	  Print the next record in the current database.

       quit
	  Exit tdbtool.

CAVEATS

       The contents of the Samba TDB files are private to the implementation and should not be altered with tdbtool.

VERSION

       This man page is correct for version 3.0.25 of the Samba suite.

AUTHOR

       The original Samba software and related utilities were created by Andrew Tridgell. Samba is now developed by the  Samba	Team  as  an  Open
       Source project similar to the way the Linux kernel is developed.

																	TDBTOOL(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

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

Discussion started by: zhynxn

2. Shell Programming and Scripting

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

Discussion started by: navojit dutta

3. Shell Programming and Scripting

Delete Strings that are present in another file

Discussion started by: jathin12

4. Shell Programming and Scripting

converting all records of a file in to one record

Discussion started by: rsriramiyer