Concatenate column values when header is Matching from multiple files

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparing same column from two files, printing whole row with matching values

First I'd like to apologize if I opened a thread which is already open somewhere. I did a bit of searching but could quite find what I was looking for, so I will try to explaing what I need. I'm writing a script on our server, got to a point where I have two files with results. Example: File1...

2. Shell Programming and Scripting

Concatenate values in the first column based on the second column.

I have a file (myfile.txt) with contents like this: 1.txt apple is 3.txt apple is 5.txt apple is 2.txt apple is a 7.txt apple is a 8.txt apple is a fruit 4.txt orange not a fruit 6.txt zero isThe above file is already sorted using this command: sort -k2 myfile.txtMy objective is to get...

3. Shell Programming and Scripting

Extracting values based on line-column numbers from multiple text files

Dear All, I have to solve the following problems with multiple tab-separated text file but I don't know how. Any help would be greatly appreciated. I have access to Linux mint (but not as a professional). I have multiple tab-delimited files with the following structure: file1: 1 44 2 ...

4. Shell Programming and Scripting

Sum column values matching other field

this is part of a KT i am going thru. i am writing a script in bash shell, linux where i have 2 columns where 1st signifies the nth hour like 00, 01, 02...23 and 2nd the file size. sample data attached. Desired output is 3 columns which will give the nth hour, number of entries in nth hour and...

5. Shell Programming and Scripting

Sum values of specific column in multiple files, considering ranges defined in another file

I have a file (let say file B) like this: File B: A1 3 5 A1 7 9 A2 2 5 A3 1 3 The first column defines a filename and the other two define a range in that specific file. In the same directory, I have also three more files (File A1, A2 and A3). Here is 10 sample lines...

6. Shell Programming and Scripting

Compare values in two files. For matching rows print corresponding values from File 1 in File2.

- I have two files (File 1 and File 2) and the contents of the files are mentioned below. - I am trying to compare the values of Column1 of File1 with Column1 of File2. If a match is found, print the corresponding value from Column2 of File1 in Column5 of File2. - I tried to modify and use...

7. UNIX for Dummies Questions & Answers

shift values in one column as header for values in another column

Hi Gurus, I have a tab separated text file with two columns. I would like to make the first column values as headings for the second column values. Ex. >value1 subjects >value2 priorities >value3 requirements ...etc and I want to have a file >value1 subjects >value2 priorities...

8. UNIX for Dummies Questions & Answers

Rename a header column by adding another column entry to the header column name

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256...

9. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

10. Shell Programming and Scripting

Joining multiple files based on one column with different and similar values (shell or perl)

Hi, I have nine files looking similar to file1 & file2 below. File1: 1 ABCA1 1 ABCC8 1 ABR:N 1 ACACB 1 ACAP2 1 ACOT1 1 ACSBG 1 ACTR1 1 ACTRT 1 ADAMT 1 AEN:N 1 AKAP1File2: 1 A4GAL 1 ACTBL 1 ACTL7

LEARN ABOUT MOJAVE

english

English(3pm)						 Perl Programmers Reference Guide					      English(3pm)

NAME

       English - use nice English (or awk) names for ugly punctuation variables

SYNOPSIS

	   use English;
	   use English qw( -no_match_vars ) ;  # Avoids regex performance penalty
					       # in perl 5.16 and earlier
	   ...
	   if ($ERRNO =~ /denied/) { ... }

DESCRIPTION

       This module provides aliases for the built-in variables whose names no one seems to like to read.  Variables with side-effects which get
       triggered just by accessing them (like $0) will still be affected.

       For those variables that have an awk version, both long and short English alternatives are provided.  For example, the $/ variable can be
       referred to either $RS or $INPUT_RECORD_SEPARATOR if you are using the English module.

       See perlvar for a complete list of these.

PERFORMANCE

       NOTE: This was fixed in perl 5.20.  Mentioning these three variables no longer makes a speed difference.  This section still applies if
       your code is to run on perl 5.18 or earlier.

       This module can provoke sizeable inefficiencies for regular expressions, due to unfortunate implementation details.  If performance matters
       in your application and you don't need $PREMATCH, $MATCH, or $POSTMATCH, try doing

	  use English qw( -no_match_vars ) ;

       .  It is especially important to do this in modules to avoid penalizing all applications which use them.

perl v5.18.2							    2014-01-06							      English(3pm)

UNIX for Beginners Questions & Answers