Visit Our UNIX and Linux User Community


File same line delete


 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers File same line delete
# 1  
Old 05-06-2019
File same line delete

Hi, I want to do file1 to file2. Rows will be different every time. Thanks.





file1

Code:
Fru-Name :BCNMB-B       Fru-Location :/chassis-1/motherboard-1  Node-Name :LMP-1-1-1
Fru-Name :BMPP2-B       Fru-Location :/chassis-1/slot-1 Node-Name :CFPU-0
Fru-Name :BMPP2-B       Fru-Location :/chassis-1/slot-2 Node-Name :CSPU-0
Fru-Name :BMPP2-B       Fru-Location :/chassis-1/slot-3 Node-Name :USPU-0
Fru-Name :BMPP2-B       Fru-Location :/chassis-1/slot-4 Node-Name :EIPU-0
Fru-Name :BMPP2-B       Fru-Location :/chassis-1/slot-5 Node-Name :CSPU-2
Fru-Name :BMPP2-B       Fru-Location :/chassis-1/slot-6 Node-Name :USPU-2
Fru-Name :BMPP2-B       Fru-Location :/chassis-1/slot-7 Node-Name :USPU-4
Fru-Name :BMPP2-B       Fru-Location :/chassis-1/slot-8 Node-Name :EIPU-2
Fru-Name :BCNMB-B       Fru-Location :/chassis-2/motherboard-1  Node-Name :LMP-1-2-1
Fru-Name :BMPP2-B       Fru-Location :/chassis-2/slot-1 Node-Name :CFPU-1
Fru-Name :BMPP2-B       Fru-Location :/chassis-2/slot-2 Node-Name :CSPU-1
Fru-Name :BMPP2-B       Fru-Location :/chassis-2/slot-3 Node-Name :USPU-1
Fru-Name :BMPP2-B       Fru-Location :/chassis-2/slot-4 Node-Name :EIPU-1
Fru-Name :BMPP2-B       Fru-Location :/chassis-2/slot-5 Node-Name :CSPU-3
Fru-Name :BMPP2-B       Fru-Location :/chassis-2/slot-6 Node-Name :USPU-3
|kn_frud        |02.09.0000            | NA                   |NA                    |03.01.0000          |
|kn_mmcf        |2.9.000               |2.9.000               |NA                    |2.18.000            |
|kn_octf        |2.09                  |2.09                  |NA                    |3.01                |
Fru-Name :BMPP2-B       Fru-Location :/chassis-2/slot-7 Node-Name :USPU-5
Fru-Name :BMPP2-B       Fru-Location :/chassis-2/slot-8 Node-Name :EIPU-3
Fru-Name :BCNMB-B       Fru-Location :/chassis-3/motherboard-1  Node-Name :LMP-1-3-1
Fru-Name :BMPP2-B       Fru-Location :/chassis-3/slot-1 Node-Name :CSPU-4
Fru-Name :BMPP2-B       Fru-Location :/chassis-3/slot-2 Node-Name :USPU-6
Fru-Name :BMPP2-B       Fru-Location :/chassis-3/slot-3 Node-Name :USPU-8
Fru-Name :BMPP2-B       Fru-Location :/chassis-3/slot-4 Node-Name :EIPU-4
Fru-Name :BMPP2-B       Fru-Location :/chassis-3/slot-5 Node-Name :USPU-10
Fru-Name :BMPP2-B       Fru-Location :/chassis-3/slot-6 Node-Name :USPU-12
Fru-Name :BMPP2-B       Fru-Location :/chassis-3/slot-7 Node-Name :CSPU-6
Fru-Name :BMPP2-B       Fru-Location :/chassis-3/slot-8 Node-Name :EIPU-6
Fru-Name :BCNMB-B       Fru-Location :/chassis-4/motherboard-1  Node-Name :LMP-1-4-1
Fru-Name :BMPP2-B       Fru-Location :/chassis-4/slot-1 Node-Name :CSPU-5
Fru-Name :BMPP2-B       Fru-Location :/chassis-4/slot-2 Node-Name :USPU-7
Fru-Name :BMPP2-B       Fru-Location :/chassis-4/slot-3 Node-Name :USPU-9
Fru-Name :BMPP2-B       Fru-Location :/chassis-4/slot-4 Node-Name :EIPU-5
Fru-Name :BMPP2-B       Fru-Location :/chassis-4/slot-5 Node-Name :USPU-11
Fru-Name :BMPP2-B       Fru-Location :/chassis-4/slot-6 Node-Name :USPU-13
Fru-Name :BMPP2-B       Fru-Location :/chassis-4/slot-7 Node-Name :USPU-14
Fru-Name :BMPP2-B       Fru-Location :/chassis-4/slot-8 Node-Name :EIPU-7


file2
Code:
Fru-Name :BMPP2-B       Fru-Location :/chassis-2/slot-6 Node-Name :USPU-3
|kn_frud        |02.09.0000            | NA                   |NA                    |03.01.0000          |
|kn_mmcf        |2.9.000               |2.9.000               |NA                    |2.18.000            |
|kn_octf        |2.09                  |2.09                  |NA                    |3.01                |

# 2  
Old 05-06-2019
gnu version
Code:
grep -B1 '^[^F]' file1 > file2

This User Gave Thanks to nezabudka For This Post:
# 3  
Old 05-06-2019
Thanks, BR

Previous Thread | Next Thread
Test Your Knowledge in Computers #590
Difficulty: Easy
In a linear search algorithm, the input size is the number of elements in the collection (n) divided by 2.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

How to find a string in a line in UNIX file and delete that line and previous 3 lines ?

Hi , i have a file with data as below.This is same file. But actual file contains to many rows. i want to search for a string "Field 039 00" and delete that line and previous 3 lines in that file.. Can some body suggested me how can i do using either sed or awk command ? Field 004... (7 Replies)
Discussion started by: vadlamudy
7 Replies

2. Shell Programming and Scripting

How to delete either of one line from file.?

Hi gurus, I have one file it may contains one line is "START" or "FINISH" either one of them. I use below command to delete it, but it doens't work. sed '/^START\|^END/d' <inputfile > outfile anybody can help me to fix this. thanks in advance. (12 Replies)
Discussion started by: ken6503
12 Replies

3. Shell Programming and Scripting

Delete a particular line from a file

I have a file of following form 2886758410 2886758500 17 1999-Mar-18 16:26:26 1 0 52 139 1129 2886758420 2886758500 17 1999-Mar-18 16:26:35 1 0 52 139 1131 2886758420 2886758500 17 1999-Mar-18 16:26:41 0 0 56 56 1132... (4 Replies)
Discussion started by: vaibhavkorde
4 Replies

4. Shell Programming and Scripting

Delete line from file

hi all, i have trackfile.txt which contains the data as 0 /home8/mc09ats/UnixCw/t1 1 /home8/mc09ats/UnixCw/t2 2 /home8/mc09ats/UnixCw/t3 3 /home8/mc09ats/UnixCw/t4 if user says delete 1 then i want to delete 1 /home8/mc09ats/UnixCw/t2 line from... (3 Replies)
Discussion started by: AbhijitIT
3 Replies

5. Shell Programming and Scripting

Delete first line from file and more....

Hello, I have to deal with several files that will be named something like this: E00001.TXT, E00002.TXT etc. Each file will have a alpha character on the first position of the first line which I want to place in a variable, then delete the entire line leaving the remainder of text. This new file... (6 Replies)
Discussion started by: dfb500
6 Replies

6. UNIX for Dummies Questions & Answers

Delete a line from a file

Hi, Need to delete a line from a file, file is too large so cannot use vi. I know the line number that has to be deleted... How can this be done ? (8 Replies)
Discussion started by: rohini
8 Replies

7. Shell Programming and Scripting

how to delete a line from the file

Hi, I have a file which contains entries with different numbers, for example: 275|24hroff|sel,fill,dbw| 2758|24hroff|sel,fill,dbw| 2765|24hroff|sel,fill,dbw| 2920|24hroff|sel,fill,dbw| I need to delete a line which contains certian number, for instance 275 I was trying to use 'sed' but... (3 Replies)
Discussion started by: aoussenko
3 Replies

8. UNIX for Dummies Questions & Answers

How to delete line from a file

Hi , I have a file it content is like that /vol.nas/u08/aip_triage/hany/Tesko/:CC::RPAS /home/biblawh/myscript:CC::RPAS i need to search for a certain pattern inside that file and delete the line if i find this pattern without redirecting the output into another file . so i used the... (0 Replies)
Discussion started by: ramezernest
0 Replies

9. Shell Programming and Scripting

delete line in a file

Hi all, I would like to delete a line in file.txt which has a list of filename. example: file_a file_b file_c lets say i have file_b in my directory, then i should delete file_b in file.txt and get output file.txt with only file_a and file_b. Below is my script, my result is still ... (12 Replies)
Discussion started by: dta4316
12 Replies

10. UNIX for Dummies Questions & Answers

Delete line(s) from file

What is the easiest way to delete a line from a file? I have a file that contains list for Domestic and Foreign customers. I want to delete all lines staring with Foreing. TIA (4 Replies)
Discussion started by: elchalateco
4 Replies

Featured Tech Videos