Sponsored Content
Top Forums Shell Programming and Scripting awk - Matching columns between 2 files and reordering results Post 302464637 by ambroze on Wednesday 20th of October 2010 03:29:33 PM
Old 10-20-2010
I used that button. I more thing, Is there a way to match these fields for the first_name and last_name non case sensitive?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

matching columns from two files

Hey, I have two files that have exactly the same format. They are both tab-delimited and contain 12 columns. However the # of rows vary. What I want to do is match columns # 5,6 and 7 between the two files. If they do match exactly (based on numbers) then I want the whole row from file 2 to... (1 Reply)
Discussion started by: phil_heath
1 Replies

2. UNIX for Dummies Questions & Answers

Matching corresponding columns in two different files

Hi to all, I have two separated files: FILE1 "V1" "V2" "V3" Mary James Nicole Robert Francisco Sophie Nancy Antony Matt Josephine Louise Rose Mark Simon Charles FILE2 "V1" "V2" "V3"... (2 Replies)
Discussion started by: eleonoral
2 Replies

3. Shell Programming and Scripting

Help with awk Matching columns from two files

Hello, I have two files as following: #bin chrom chromStart chromEnd name score strand observed 585 chr2 29442 29443 rs4637157 0 + C/T 585 chr2 33011 33012 rs13423995 0 + A/G 585 chr2 34502 34503 rs13386087 0 + ... (2 Replies)
Discussion started by: Homa
2 Replies

4. Shell Programming and Scripting

Merge two files matching columns

Hi! I need to merge two files when col1 (x:x:x) matching and adds second column from file1.txt. # cat 1.txt aaa;a12 bbb;b13 ccc;c33 ddd;d55 eee;e11 # cat 2.txt bbb;b55;34444;d55 aaa;a15;35666;a44 I try with this awk and I get succesfully first column from 1.txt: # awk -F";"... (2 Replies)
Discussion started by: fhluque
2 Replies

5. Shell Programming and Scripting

Join two files with matching columns

Hi, I need to join two files together with one common value in a column. I think I can use awk or join or a combination but I can't quite get it. Basically my data looks like this, with the TICKER columns matching up in each file File1 TICKER,column 1, column, 2, column, 3, column 4 ... (6 Replies)
Discussion started by: unkleruckus
6 Replies

6. Shell Programming and Scripting

awk to copy previous line matching a particular columns

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)
Discussion started by: Indra2011
3 Replies

7. Shell Programming and Scripting

awk - matching on 2 columns for differents lines

Given this file (I separated them in block to make my explanation clearer): 92157768877;Sof_deme_Fort_Email_am_%yyyy%%mm%%dd%;EMAIL;20/02/2015;1;0;0 92157768877;Sof_trav_Fort_Email_am_%yyyy%%mm%%dd%;EMAIL;20/02/2015;1;0;0 91231838895;Sof_deme_faible_Email_am;EMAIL;26/01/2015;1 0;0... (1 Reply)
Discussion started by: Andy_K
1 Replies

8. Shell Programming and Scripting

awk merge matching columns

I know I'm not the first one asking this but my code still does not work: File 1: gi|1283| tRNAscan exon 87020 88058 . - . transcript_id "Parent=tRNA-Tyr5.r01"; gi|3283| tRNAscan exon 97020 97058 . + . transcript_id "Parent=tRNA-Tyr6.r01"; gi|4283| rRNAscan exon 197020 197058 . - . transcript_id... (5 Replies)
Discussion started by: 0sMoses
5 Replies

9. Shell Programming and Scripting

Joining Two Files Matching Two Columns

Hi All, I am looking to join two files where column 1 of file A matches with column 1 of file B and column 5 of files A matches with column 2 of file B. After joining the files based on above condition, out should contain entire line of file A and column 3, 4 and 5 of file B. Here is sample... (8 Replies)
Discussion started by: angshuman
8 Replies

10. Shell Programming and Scripting

awk Matching Columns - Am I missing something?

I am using awk to match columns and output based on those matches. For some reason it is not printing matching columns, am I missing something? Operating system - windows with cygwin. Command that I am using: sed 's/]*,]*/,/g' $tempdir/file1 > $tempdir/file1.$$ && awk -F, 'FNR==NR{f2=$2... (7 Replies)
Discussion started by: dis0wned
7 Replies
RHNREG_KS(8)						    Red Hat Linux System Manual 					      RHNREG_KS(8)

NAME
rhnreg_ks - a program for non interactively registering systems to Red Hat Network SYNOPSIS
rhnreg_ks [OPTION]... [PACKAGE NAME]... DESCRIPTION
rhnreg_ks is a utility for registering a system with the Red Hat Network. It is designed to be used in a non-interactive enviroment (a kickstart style install, for example). All the information can be specified on the commandline or stdin. --profilename Specify the profilename that should be used as an identifier for the system in Red Hat Network --username The username to register the system with under Red Hat Network. This can be an existing Red Hat Network username, or a new username. --password The password associated with the username specified with the --username option. This is an unencrypted password. --orgid Specify an organizational id of the org to register this system under. This is optional, and only used if registered a system to an existing Red Hat Network organization. --orgpassword The password assocated with the orgig specified with the --orgid option. This is an unencrypted password. --email The email address associated with the username specified iwth the --username option. --serialnumber Specify a servial number to associate with the system. This is optional, and only useful when combined with an orgid. --contactinfo Read contact info from standard in. The format is one entry per line, colon seperated. Valid options are reg_num, title, first_name, last_name, company, position, address1, address2, city, state, zip, country, phone, fax, contact_email, contact_mail, contact_phone, contact_fax, contact_special, contact_newsletter. --nohardware Do not probe or upload any hardware information. --nopackages Do not profile or upload any package information. --force Register the system even if it has already been registered. --version Show the version fo rhnreg_ks --proxy Specify a http proxy to use. FILES
/etc/sysconfig/rhn/up2date Configuration settings for up2date and rhnreg_ks /usr/share/rhn/RHNS-CA-CERT The ssl certificate authority file used by rhnreg_ks to validate the Red Hat Network ssl servers. EXAMPLES
The following registers a new system to Red Hat Network. rhnreg_ks --profilename "example_profile_name" --username "someexampleuser@example.com" --password "foobar" The following examples registers a new system to Red Hat Network including contact info. rhnreg_ks --profilename "example_profile_name" --username "someexampleuser@example.com" --password "foobar" --contactinfo < contactinfo where the file "contactinfo" contains data in the format: first_name: Billy last_name: Bob company: SomeCompanyName city: Springfield fax: 555-5555 phone: 555-5555 SEE ALSO
Configuration can be done via up2date --configure. rhnreg_ks is used to register a system to Red Hat Network. Visit <http://rhn.red- hat.com> for access or to sign up. You can also run up2date to register a system with Red Hat Network. Authors Written by Adrian Likins <alikins@redhat.com> REPORTING BUGS
Report bugs to <http://bugzilla.redhat.com>. COPYRIGHT
Copyright (C) 1999-2002 Red Hat, Inc. This is free software; see the source for copying conditions. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICU- LAR PURPOSE. 4th Berkeley Distribution Wed 10 April 2002 RHNREG_KS(8)
All times are GMT -4. The time now is 08:02 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy