Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Delete line in file based on data in another file

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Delete line in file based on data in another file
Prev   Next
# 1  
Old 12-29-2008
Question Delete line in file based on data in another file
Hi there

I would like to create a shell script to do the following:
- delete a line in file1 if it contains the data string in file2
eg: file1
1 100109942004051510601703694 0.00 0.00
2 100109942004051510601702326 0.00 0.00
3 100109942004051510601702327 0.00 0.00
file2
1 3694
2 3741
3 3834
In the above example line1 of file1 must be deleted because it contains the string of line1 in file2 "3694".
Also, the data sting must be in position 24 in each line
100109942004051510601703694 0.00 0.00
for it to be deleted.
Hope this is sufficient information for a possible solution.
I never did any shell scripting before so the help would very much be appreciated. Smilie
Thanks
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Delete the records in file based on lookup file.

Hi I have two files one.txt and two.txt one.txt 123 324 456 235 456 two txt abc one 000 123 abc abc one 000 456 abc abc one 000 122 abc abc one 000 111 abc My question here is, the records which are present in one.txt has to deleted in second file two.txt my output result... (2 Replies)
Discussion started by: Ganesh L
2 Replies

2. Shell Programming and Scripting

Replace line in file with line in another file based on matching string

HI Can any one guide me how to achieve this task. I have 2 files env.txt #Configuration.Properties values identity_server_url = http://identity.test-hit.com:9783/identity/service/user/register randon_password_length = 6 attachment_file_path = /pass/temp/attachments/... (1 Reply)
Discussion started by: nikilbr86
1 Replies

3. Shell Programming and Scripting

Replace and add line in file with line in another file based on matching string

Hi, I want to achieve something similar to what described in another post: The difference is I want to add the line if the pattern is not found. File 1: A123, valueA, valueB B234, valueA, valueB C345, valueA, valueB D456, valueA, valueB E567, valueA, valueB F678, valueA, valueB ... (11 Replies)
Discussion started by: jyu3
11 Replies

4. UNIX for Dummies Questions & Answers

using sed delete a line from csv file based on specific data in two separate fields

Hello, :wall: I have a 12 column csv file. I wish to delete the entire line if column 7 = hello and column 12 = goodbye. I have tried everything that I can find in all of my ref books. I know this does not work /^*,*,*,*,*,*,"hello",*,*,*,*,"goodbye"/d Any ideas? Thanks Please... (2 Replies)
Discussion started by: Chris Eagleson
2 Replies

5. UNIX for Dummies Questions & Answers

Mapping a data in a file and delete line in source file if data does not exist.

Hi Guys, Please help me with my problem here: I have a source file: 1212 23232 343434 ASAS1 4 3212 23232 343434 ASAS2 4 3234 23232 343434 QWQW1 4 1134 23232 343434 QWQW2 4 3212 23232 343434 QWQW3 4 and a mapping... (4 Replies)
Discussion started by: kokoro
4 Replies

6. Shell Programming and Scripting

Replace line in file with line in another file based on matching string

Hi I am not the best scripter in the world and have run into a issue which you might be able to guide me on... I have two files. File1 : A123, valueA, valueB B234, valueA, valueB C345, valueA, valueB D456, valueA, valueB E567, valueA, valueB F678, valueA, valueB File2: C345,... (5 Replies)
Discussion started by: luckycharm
5 Replies

7. Shell Programming and Scripting

Delete lines line by match data 2 file.

i need to delete the lines is match from file data 1 & data 2 please help? data 1 4825307 4825308 4825248 4825309 4825310 4825311 4825336 data 2 4825248 0100362210 Time4Meal 39.00 41.73 MO & MT MT SMS 4825305 0100367565... (2 Replies)
Discussion started by: ooilinlove
2 Replies

8. Shell Programming and Scripting

Delete rows based on line numbers in a file

I have to find the number of rows in a file and delete those many rows in another file. For example, if I have 3 rows in a file A, i have to delete first 3 rows in anothe file B, I have the code, it works as standalone, when I merge this with m application (c with unix), it doesnt work. ... (2 Replies)
Discussion started by: Muthuraj K
2 Replies

9. Shell Programming and Scripting

Delete block of text in one file based on list in another file

Hi all I currently use the following in shell. #!/bin/sh while read LINE do perl -i -ne "$/ = ''; print if !m'Using archive: ${LINE}'ms;" "datafile" done < "listfile" NOTE the single quote delimiters in the expression. It's highly likely the 'LINE' may very well have characters in it... (3 Replies)
Discussion started by: Festus Hagen
3 Replies

10. Shell Programming and Scripting

i want to delete a file based on existing file in a directory

hi i am having four files in a directory.like 1)sampleRej 2)exampleRej 3)samplemain 4)examplemain my requirement is i have to search for the rejected files (sampleRej,exampleRej) in a directory.if these files in that directory then i have to delete the main files... (3 Replies)
Discussion started by: srivsn
3 Replies
Login or Register to Ask a Question

LEARN ABOUT DEBIAN

h5diff

h5diff(1)						      General Commands Manual							 h5diff(1)

NAME

       h5diff - Compares two HDF5 files and reports the differences.

SYNOPSIS

       h5diff file1 file2 [OPTIONS] [object1 [object2 ] ]

DESCRIPTION

       h5diff is a command line tool that compares two HDF5 files, file1 and file2, and reports the differences between them.

       Optionally,  h5diff  will compare two objects within these files. If only one object, object1, is specified, h5diff will compare object1 in
       file1 with object1 in file2. In two objects, object1 and object2, are specified, h5diff will compare  object1  in  file1  with  object2	in
       file2. These objects must be HDF5 datasets.

       object1 and object2 must be expressed as absolute paths from the respective file's root group.

       Additional information, with several sample cases, can be found in the document H5diff Examples.

OPTIONS

       file1 file2
	      The HDF5 files to be compared.

       -h     Print all differences.

       -r     Print  only  the	names  of  objects that differ; do not print the differences. These objects may be HDF5 datasets, groups, or named
	      datatypes.

       -n count
	      Print difference up to count differences, then stop. count must be a positive integer.

       -d delta
	      Print only differences that are greater than the limit delta. delta must be a positive number. The comparison criterion  is  whether
	      the  absolute  value of the difference of two corresponding values is greater than delta (e.g., |a-b| > delta, where a is a value in
	      file1 and b is a value in file2).

       -p relative
	      Print only differences that are greater than a relative error. relative must be a  positive  number.  The  comparison  criterion	is
	      whether the absolute value of the difference 1 and the ratio of two corresponding values is greater than relative (e.g., |1-(b/a)| >
	      relative where a is a value in file1 and b is a value in file2).

       object1 object2
	      Specific object(s) within the files to be compared.

EXAMPLES

       The following h5diff call compares the object /a/b in file1 with the object /a/c in file2:
	   h5diff file1 file2 /a/b /a/c

       This h5diff call compares the object /a/b in file1 with the same object in file2:
	   h5diff file1 file2 /a/b

       And this h5diff call compares all objects in both files:
	   h5diff file1 file2

SEE ALSO

       h5dump(1), h5ls(1), h5repart(1), h5import(1), gif2h5(1), h52gif(1), h5perf(1)

																	 h5diff(1)