Let's say we have following Input_file:
Then as per your conditions provided in post, could you please try following code and let me know if that helps.
Output will be as follows.
If this code doesn't match with your requirement and you have more conditions to your requirement, request you to please show a bit more sample Input_file with sample output too.
EDIT: Let's say you have more than 2 consecutive lines and you want to match all, then following may help.
Following is the Input_file:
Then following is the code for above Input_file:
Output will be as follows.
Thanks,
R. Singh
Last edited by RavinderSingh13; 11-21-2015 at 02:33 AM..
Reason: Changed Input_file a bit. Added one more condition with solution too.
This User Gave Thanks to RavinderSingh13 For This Post:
Following may help you in same. Again considering that you are comparing only consecutive 2 lines each time.
Output will be as follows.
Also not sure why you haven't mentioned last 2 lines of above output in your required sample output as per your condition their first four columns too are not matching so they should come too, let me know if you have any queries.
Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
Hello Help,
2356798 7689867 999 000
123678 20385907 9797 666
17978975 87468976 968978 98798
I am trying to have out put which actually look for the third column value of 9797 and then it insert line there after with first, second column value exactly as the previous line and replace the third... (3 Replies)
Hello,
I have two files file 1 and file 2 each having result of a query on certain database tables and need to compare for Col1 in file1 with Col3 in file2, compare Col2 with Col4 and output the value of Col1 from File1 which is a) not present in Col3 of File2 b) value of Col2 is different from... (2 Replies)
Hi,
I want to match the pattern in file1 with file2 and print the value in file2 and paste in file1
file1:
ISHO RT SR Major 96.46778
Drop Call Rate CS Critical 0.5072662
ISHO RT SR Major 97.754364... (3 Replies)
I'm looking to remove duplicate rows from a CSV file with a twist.
The first row is a header.
There are 31 columns. I want to remove duplicates when the first 29 rows are identical ignoring row 30 and 31 BUT the duplicate that is kept should have the shortest total character length in rows 30... (6 Replies)
Hello Friends,
I have a CDR file and i need to print out 2 columns with their field position which matches to some constant values,
a part of input file
CZ=1|CZA=1|DIAL=415483420001|EE=13|ESF=1|ET=|FF=0|9|MNC=99|MNP=9041|MTC=0|NID=2|NOA=international|ON=1|
OutPut
... (3 Replies)
Hi all,
on Solaris 10, I'd like to print a range of lines starting at pattern but also including the very first line before pattern.
the following doesn't print the range starting at pattern and going down to the end of file: cat <my file> | sed -n -e '/<pattern>{x;p;}/'
I need to include the... (1 Reply)
Hi,
I wish to use a column, as inputted by a user from command line, for pattern matching.
awk file:
{
if($1 ~ /^8/)
{
print $0> "temp2.csv"
}
}
something like this, but i want '$1' to be any column as selected by the user from command line.
... (1 Reply)
Hi ,
I have 5 columns total and am wanting to search lines in columns 3-5 and basically grep -v patterns that match 'BBB_0123' 'BVG_0895' 'BSD_0987'
Does anyone know how to do this? I tried combining grep -v with grep -e but, it didn't work.
Thanks! (5 Replies)