Sponsored Content
Full Discussion: Column matching
Top Forums Shell Programming and Scripting Column matching Post 302940040 by Akshay Hegde on Wednesday 1st of April 2015 12:39:11 AM
Old 04-01-2015
Please show attempts at a solution.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

matching each line in a column to an array

Hi, I have two files: file 1 has a list : ABC_1024 ABC_4507 ABC_5589 ERT_4389 DDB_5507 file 2 has an array: ABC_1011,ABC_1024,ABC_5670 DDB_4567 ERT_2345 January08 ABC_9099 DDB_9087 ERT_4567 March07 I need to go line by line in file 1... (2 Replies)
Discussion started by: greptastic
2 Replies

2. Shell Programming and Scripting

Matching 2 files based on one column

Hi, On a similar subject, the following. I have two files: file1.txt dbSNP_rsID,Chromosome,Position,Gene rs10399749,chr. 01,45162,? rs4030303,chr. 01,72434,? rs4030300,chr. 01,72515,? rs940550,chr. 01,78032,? rs13328714,chr. 01,81468,? rs11490937,chr. 01,222077,? rs6683466,chr.... (5 Replies)
Discussion started by: swvanderlaan
5 Replies

3. Shell Programming and Scripting

Join 3 or more files using matching column

Dear Forum, Full title of the topic would be: "Join 3 or more files using matching column without full list in any of these columns" I have several, typically 3 or 4 files which I need to join, something like FULL JOIN in slq scripts, all combinations of matches should be printed into an... (3 Replies)
Discussion started by: cyz700
3 Replies

4. Shell Programming and Scripting

Find lines with matching column 1 value, retain only the one with highest value in column 2

I have a file like: I would like to find lines lines with duplicate values in column 1, and retain only one based on two conditions: 1) keep line with highest value in column 3, 2) if column 3 values are equal, retain the line with the highest value in column 4. Desired output: I was able to... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

5. Shell Programming and Scripting

Column string matching in awk

Hello, I want pick up rows from input with conditions: 1) col2 is 2 replicate of col1 joint with "/" 2) col3 is a joint string as replicate of each side of the "/" symbol 3) col2 not equal to col3 input: TG TG/TG TG/TGG C C/C C/CG C C/G CA/CA C C/C CA/CA AG AG/AG... (3 Replies)
Discussion started by: yifangt
3 Replies

6. Shell Programming and Scripting

Matching two files per column

Hi, I hope somebody can help me with this problem, since I would like to solve this problem using awk, but im not experienced enough with this. I have two files which i want to match, and output the matching column name and row number. One file contains 4 columns like this: FILE1: a ... (6 Replies)
Discussion started by: Jenna.bos
6 Replies

7. Shell Programming and Scripting

Matching column then append to existing File as new column

Good evening I have the below requirements, as I am not an experts in Linux/Unix and am looking for your ideas how I can do this. I have file called file1 and file2. I need to get the second column which is text1_random_alphabets and find that in file 2, if it's exists then print the 3rd... (4 Replies)
Discussion started by: mychbears
4 Replies

8. Shell Programming and Scripting

Proper Column wise matching

My below code works fine if none of the columns has pipe as its content in it, If it has the pipe in any of the content then the value moves to the next column. I wanted my code to work fine even if the column has pipe in it apart from the delimiter. NOTE : If there is a pipe in the content... (6 Replies)
Discussion started by: nikhil jain
6 Replies

9. Shell Programming and Scripting

Matching column value from 2 different file using awk and append value from different column

Hi, I have 2 csv files. a.csv HUAWEI,20LMG011_DEKET_1296_RTN-980_IDU-1-11-ISV3-1(to LAMONGAN_M),East_Java,20LMG011_DEKET_1296_RTN-980_IDU-1,20LMG011,20LMG 027_1287_LAMONGAN_RTN980_IDU1,20LMG027,1+1(HSB),195.675,20LMG011-20LMG027,99.9995,202.6952012... (7 Replies)
Discussion started by: tententen
7 Replies

10. UNIX for Beginners Questions & Answers

Matching column search in two files

Hi, I have a tab delimited file1: NC_013499.1 3180 3269 GQ342961.1 NC_030295.1 5925 6014 FN398100.2 NC_007915.1 6307 6396 KU529284.1 NC_013499.1 5033 5122 GQ342961.1 And a second file2: NC_030295.1 RefSeq gene 136 5115 ... (6 Replies)
Discussion started by: Ibk
6 Replies
eurephiadm attempts(7)													    eurephiadm attempts(7)

NAME
eurephiadm-attempts - Manage the attempts log in eurephia DESCRIPTION
When a remote user fails to authenticate correctly, the attemp will be logged. After a certain amount of attempts the IP address, certifi- cate and/or user account will be blocked. The eurephiadm attempts command is used to get an overview over what is registered as failed attempts and to give the possibility to reset or delete the registered attempts counter. Available modes for the attempts command are: -D | --delete Delete a registered login attempt -R | --reset Reset a registered login attempt -l | --list List all registered login attempts -h | --help <mode> Show help DELETE MODE
The attempts delete mode will remove a record from the attempts log. One of the following parameters must be given (only one): -u | --username <username> User name to delete -d | --digest <SHA1 digest> Certificate SHA1 digest to delete -i | --ipaddr <IP address> IP address to delete -a | --attemptid <ID> Attempts record ID to delete RESET MODE
The attempts reset mode will reset the attempt counter. One of the following parameters must be given (only one): -u | --username <username> User name to reset -d | --digest <SHA1 digest> Certificate SHA1 digest to reset -i | --ipaddr <IP address> IP address to reset -a | --attemptid <ID> Attempts record ID to reset LIST MODE
The attempts list mode will show all registered login attempts. -v | --verbose Show more details Filters: -u | --username <username> List only attempts matching the given user name -d | --digest <SHA1 digest> List only attempts matching the given SHA1 certificate digest -i | --ipaddr <IP address> List only attempts matching the given IP address SEE ALSO
eurephiadm-blacklist(7), eurephia-config(7) AUTHOR
Copyright (C) 2008-2010 David Sommerseth <dazo@users.sourceforge.net> David Sommerseth July 2010 eurephiadm attempts(7)
All times are GMT -4. The time now is 07:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy