Ok, so now we have a clear understanding of what the outout should look like. So you want values that have themselves as counter values to be 0 in the last column. I noticed in your output there was also a zero, presumably from an empty line. But I don not know why some parts start on a new line. To counteract the empty line and to cater for entries that might lack a reversed counterpart I used NF and reintroduced the +0 bit. I took RudiC's and Akshay's suggestions and made a couple of changes:
Last edited by Scrutinizer; 02-02-2014 at 12:28 PM..
Hi,
I have a challenging task,in which i have to find the duplicate files by its name and size,then i need to take anyone of the file.Then i need to open the file and find for more than one pattern and count of that pattern.
Note:These are the samples of two files,but i can have more... (2 Replies)
I am trying to figure out how to scan a file like so:
1 ralphs office","555-555-5555","ralph@mail.com","www.ralph.com
2 margies office","555-555-5555","ralph@mail.com","www.ralph.com
3 kims office","555-555-5555","kims@mail.com","www.ralph.com
4 tims... (17 Replies)
Hi all,
I am wondering if its possible to solve my problem with a simple code.
Basically I have a file that looks like this (tab delimited)
bob 8 250 tina 8 225
sam 8 225 ellen 9 315
kyle 9 275 sally 9 135
So what I want to do is match columns 2 and 5. If columns 2 and 5... (2 Replies)
Hi team,
I have 20 columns csv files. i want to find the duplicates in that file based on the column1 column10 column4 column6 coulnn8 coulunm2 . if those columns have same values . then it should be a duplicate record.
can one help me on finding the duplicates,
Thanks in advance.
... (2 Replies)
Hi All,
I want someone to modify the below script from this forum so that it can be used for all columns in the file( instead of only printing column 3 mean and standard deviation values). I don't know how to loop around all the columns.
... (3 Replies)
Hi everybody,
I am a complete novice and please forgive if its answered gazillion times
I have a file which looks like this
1 0 2 0 0 0 0 0
0 3 0 1 18 2 6 0
1 7 0 2 4 0 0 0
1 17 16 1 1 0 0
I have to add... (4 Replies)
Hi,
I have a requirement.for eg: i have a text file with pipe symbol as delimiter(|) with 4 columns a,b,c,d. Here a and b are primary key columns..
i want to process that file to find the duplicates and null values are in primary key columns(a,b) . I want to write the unique records in which... (5 Replies)
Hello, I need to find the intersection across 10 columns. Kindly help.
my file (INPUT.csv) looks like this
4_R 4_S 8_R 8_S 12_R 12_S 24_R 24_S
LOC_Os01g01010 LOC_Os01g01010 LOC_Os01g01010 LOC_Os04g48290 LOC_Os01g01010 LOC_Os01g01010... (1 Reply)