Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Joining string on multiple files
Top Forums UNIX for Dummies Questions & Answers Joining string on multiple files Post 302431309 by jdr0317 on Monday 21st of June 2010 12:18:42 PM
Old 06-21-2010
Joining string on multiple files
Hi guys,

I am a forum (and a bit of a unix) newbie, and I currently have a tricky problem lying ahead of me. I have multiple files, and I am looking to join the files on the first column.

Example:

File 1
Code:
andy b  100
amy c  200
amy d  300

File 2
Code:
andy c  200
amy c  100
clyde o 50

File 3
Code:
andy c  300
andy b  100
clyde o 50

File 4
Code:
amy c  200
clyde a  50
clyde o  50

So, what I would need to produce is something like this:

Code:
Name   1       2      3      4
amy c  200   100           200
amy d  300
andy b 100            100
andy c          200   300
clyde a                          50
clyde o          50     50    50

Any advice on how to handle this?
Note that I would be printing out a name, and its corresponding number values, leaving blank wherever a corresponding number does not exist.
Last edited by Franklin52; 06-22-2010 at 03:34 AM.. Reason: Please use code tags!
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Joining files based on multiple keys

I need a script (perl or awk..anything is fine) to join 3 files based on three key columns. The no of non-key columns can vary in each file. The columns are delimited by semicolon. For example, File1 Dim1;Dim2;Dim3;Fact1;Fact2;Fact3;Fact4;Fact5 ---- data delimited by semicolon --- ... (1 Reply)
Discussion started by: Sebben
1 Replies

2. Shell Programming and Scripting

Multiple search string in multiple files using awk

Hi, filenames: contains name of list of files to search in. placelist contains the names of places to be searched in all files in "filenames" for i in $(<filenames) do egrep -f placelist $i if ] then echo $i fi done >> outputfile Output i am getting: (0 Replies)
Discussion started by: pinnacle
0 Replies

3. Shell Programming and Scripting

joining multiple files into one while putting the filename in the file

Hello, I know how to join multiple files using the cat function. I want to do something a little more advanced. Basically I want to put the filename in the first column... One thing to note is that the file is tab delimited. e.g. file1.txt joe 1 4 5 6 7 3 manny 2 3 4 5 6 7 ... (4 Replies)
Discussion started by: phil_heath
4 Replies

4. Shell Programming and Scripting

Need help joining two files with a common string

Hi all, I have one file that is in the form: S0243K05_T7_S0243K05_|_BASS2243.C7_K05 groupVI. 88.76 S0137F20_SP6_S0137F20_|_BASS2137d.SPB2.2_C10 groupXXI 88.06 S0056F03_T7_S0056F03_|_BASS256c.C7_C02 groupXIX 85.99 S0056F03_T7_S0056F03_|_BASS256c.C7_C02 groupXIX 83.23... (3 Replies)
Discussion started by: repiv
3 Replies

5. 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 (4 Replies)
Discussion started by: seqbiologist
4 Replies

6. Shell Programming and Scripting

Script to find & replace a multiple lines string across multiple php files and subdirectories

Hey guys. I know pratically 0 about Linux, so could anyone please give me instructions on how to accomplish this ? The distro is RedHat 4.1.2 and i need to find and replace a multiple lines string in several php files across subdirectories. So lets say im at root/dir1/dir2/ , when i execute... (12 Replies)
Discussion started by: spfc_dmt
12 Replies

7. Shell Programming and Scripting

Other alternative for joining together columns from multiple files

Hi again, I have monthly one-column files of roughly around 10 years. Is there a more efficient way to concatenate these files column-wise other than using paste command? For instance: file1.txt 12 13 15 12 file2.txt 14 15 18 19 file3.txt 20 21 (8 Replies)
Discussion started by: ida1215
8 Replies

8. Shell Programming and Scripting

Joining multiple files tail on tail

I have 250 files that have 16 columns each - all numbered as follows stat.1000, stat.1001, stat.1002, stat.1003....stat.1250. I would like to join all 250 of them together tail by tail as follows. For example stat.1000 a b c d e f stat.1001 g h i j k l So that my output... (2 Replies)
Discussion started by: kayak
2 Replies

9. UNIX for Dummies Questions & Answers

Joining different columns from multiple files

Hello again, I am trying to join 3rd column of 3 files into the end on one file and save it separately... my data looks like this file 1 Bob, Green, 80 Mark, Brown, 70 Tina, Smith, 60 file 2 Bob, Green, 70 Mark, Brown, 60 Tina, Smith, 50 file 3 Bob, Green, 50 Mark, Brown,60 Tina,... (6 Replies)
Discussion started by: A-V
6 Replies

10. Shell Programming and Scripting

CSV joining and checking multiple files

Hello, For our work we use several scripts to gather/combine data for use in our webshop. Untill now we did not had any problems but since a couple days we noticed some mismatches between imports. It happened that several barcodes where matched even though it was a complete other product. Of... (19 Replies)
Discussion started by: SDohmen
19 Replies

LEARN ABOUT DEBIAN

tm::coverage

TM::Coverage(3pm)					User Contributed Perl Documentation					 TM::Coverage(3pm)

NAME

       TM::Coverage - Topic Maps, Code Coverage

DESCRIPTION

       This auxiliary package keeps track of the code coverage. Probably quite irrelevant for a user.

       Automatically generated for TM (1.44).

	  ---------------------------- ------ ------ ------ ------ ------ ------ ------
	  File				 stmt	bran   cond    sub    pod   time  total
	  ---------------------------- ------ ------ ------ ------ ------ ------ ------
	  blib/lib/TM.pm		 96.4	84.5   58.0   93.7   90.6   27.5   89.6
	  blib/lib/TM/Analysis.pm	100.0	90.9	n/a  100.0  100.0    0.0   97.5
	  blib/lib/TM/AsTMa/Fact.pm	100.0	 n/a	n/a  100.0    n/a    0.0  100.0
	  blib/lib/TM/AsTMa/Fact2.pm	100.0	 n/a	n/a  100.0    n/a    0.0  100.0
	  blib/lib/TM/Bulk.pm		 76.8	71.4   62.5   85.7  100.0    0.0   75.3
	  blib/lib/TM/CTM/CParser.pm	 65.6	34.3   31.0   84.6    0.0    1.6   52.5
	  blib/lib/TM/CTM/Parser.pm	 90.9	50.0	n/a  100.0    0.0    0.0   79.4
	  blib/lib/TM/DM.pm		100.0	65.0   66.7  100.0    n/a    0.0   96.5
	  blib/lib/TM/Graph.pm		 99.1	88.5	n/a  100.0  100.0    0.0   97.4
	  blib/lib/TM/Index.pm		100.0	80.0   60.0  100.0   83.3    0.3   87.8
	  .../Index/Characteristics.pm	100.0  100.0	n/a  100.0    0.0    0.0   97.0
	  blib/lib/TM/Index/Match.pm	 98.5	87.5	n/a  100.0  100.0    0.5   97.6
	  blib/lib/TM/LTM/CParser.pm	 84.9	45.3   42.7   98.2    0.0    0.2   67.8
	  blib/lib/TM/LTM/Parser.pm	 95.7	62.5   50.0  100.0    0.0    0.0   87.1
	  blib/lib/TM/Literal.pm	 45.8	 0.0   11.8   30.0    0.0    0.4   24.2
	  blib/lib/TM/MapSphere.pm	 96.5	84.6   68.8  100.0  100.0    0.0   91.7
	  .../TM/Materialized/AsTMa.pm	100.0	 n/a	n/a  100.0    0.0    0.0   95.5
	  ...ib/TM/Materialized/LTM.pm	100.0	 n/a	n/a  100.0    0.0    0.0   95.5
	  .../TM/Materialized/MLDBM.pm	100.0	83.3	n/a  100.0    0.0    0.0   92.6
	  ...b/TM/Materialized/Null.pm	100.0	 n/a	n/a  100.0    n/a    0.0  100.0
	  ...TM/Materialized/Stream.pm	100.0  100.0  100.0  100.0    0.0    0.0   96.0
	  ...ib/TM/Materialized/XTM.pm	100.0	 n/a	n/a  100.0    0.0    0.0   96.7
	  blib/lib/TM/PSI.pm		100.0	 n/a	n/a  100.0    n/a    0.0  100.0
	  blib/lib/TM/QL.pm		 91.4	61.5   66.7  100.0   50.0    0.1   83.9
	  blib/lib/TM/QL/CParser.pm	 76.2	42.4   41.9   90.3    0.0    9.1   62.0
	  blib/lib/TM/QL/PE.pm		 83.8	77.3   80.0   91.7    0.0   52.5   80.5
	  blib/lib/TM/QL/TS.pm		 65.2	35.4   27.8   70.8   53.3    2.4   56.9
	  blib/lib/TM/ResourceAble.pm	 88.1	87.5	n/a  100.0  100.0    0.0   90.0
	  .../TM/ResourceAble/MLDBM.pm	100.0	75.0	n/a  100.0    0.0    0.0   94.2
	  blib/lib/TM/Serializable.pm	 94.9	65.6  100.0  100.0  100.0    0.0   84.1
	  .../TM/Serializable/AsTMa.pm	 99.1	87.9   66.7  100.0  100.0    0.0   94.2
	  ...TM/Serializable/Dumper.pm	100.0	 n/a	n/a  100.0    0.0    0.0   93.5
	  ...ib/TM/Serializable/LTM.pm	 94.1	 n/a	n/a   83.3  100.0    0.0   92.0
	  ...ib/TM/Serializable/XTM.pm	 96.3	85.2   72.9  100.0  100.0    0.2   91.5
	  .../lib/TM/Synchronizable.pm	100.0	75.0  100.0  100.0  100.0    0.0   97.2
	  ...M/Synchronizable/MLDBM.pm	100.0	50.0	n/a  100.0    0.0    0.0   89.3
	  ...nchronizable/MapSphere.pm	100.0	63.6   64.3  100.0  100.0    0.0   88.6
	  ...TM/Synchronizable/Null.pm	100.0	 n/a	n/a  100.0    0.0    0.0   87.5
	  blib/lib/TM/Tau.pm		100.0	91.7   80.0  100.0    0.0    0.0   95.6
	  blib/lib/TM/Tau/Federate.pm	 63.2	39.3	n/a   62.5   27.3    0.0   54.5
	  blib/lib/TM/Tau/Filter.pm	100.0	91.7   66.7  100.0   50.0    0.0   90.0
	  .../TM/Tau/Filter/Analyze.pm	100.0	 n/a	n/a  100.0  100.0    0.0  100.0
	  blib/lib/TM/Tree.pm		100.0	57.1   44.4  100.0   66.7    0.0   88.0
	  blib/lib/TM/Utils.pm		100.0	50.0	n/a  100.0    0.0    0.0   89.3
	  ...ib/TM/Utils/TreeWalker.pm	100.0  100.0	n/a  100.0    0.0    0.0   96.0
	  ...ib/TM/Workbench/Plugin.pm	100.0	 n/a	n/a  100.0    0.0    0.0   75.0
	  ...M/Workbench/Plugin/Tau.pm	 87.5	50.0	n/a   80.0    0.0    0.0   73.1
	  yapp/astma-fact.yp		 96.9	91.5   73.3   97.8    0.0    4.8   92.7
	  yapp/astma2-fact.yp		 97.4	91.6   58.3  100.0    0.0    0.2   91.6
	  Total 			 76.8	45.2   40.2   91.2   57.0  100.0   63.8
	  ---------------------------- ------ ------ ------ ------ ------ ------ ------

SEE ALSO

       TM

COPYRIGHT AND LICENSE

       Copyright 200[8] by Robert Barta, <drrho@cpan.org>

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.10.1							    2008-10-05							 TM::Coverage(3pm)
All times are GMT -4. The time now is 02:24 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy