Joining files in a complex way Post: 302401423

Sponsored Content

Top Forums Shell Programming and Scripting Joining files in a complex way Post 302401423 by stateperl on Saturday 6th of March 2010 03:37:48 AM

03-06-2010

Banned

Here is an example

@Tyler: Thanx for perl script. It looking bit scary to me but as smart as awk. Smilie

**********************************************************************************************

It's multiple input1 files and a single input2 file. In this we need to sum up all the Stype_No from input1a,b,c files.Mentioned in bold. so it should work like this.
Note; To make it easy for you I just used same copies of input1 files (a,b and c) but in real cases the number od A/A or others may vary and also the number of input1 files may be greater than just 3 (it could be input a,b,c,d or ....).

Code:

perl script.pl input1a input1b input1c input2 >>output

input1a

Code:

"aphab"    "S1"    "S2"    "S3"
"a"    "A/A"    "A/A"    "A/A"
"b"    "A/G"    "A/G"    "A/A"
"c"    "A/A"    "G/G"    "A/A"
"d"    "G/G"    "A/G"    "A/G"
"e"    "A/G"    "G/G"    "A/G"
"f"     "A/A"    "G/G"    "A/G"
"g"    "A/A"    "G/G"    "G/G"
"h"    "A/A"    "G/G"    "G/G"
"I"     "A/A"    "G/G"    "G/G"

input1b

Code:

"aphab"    "S1"    "S2"    "S3"
"a"    "A/A"    "A/A"    "A/A"
"b"    "A/G"    "A/G"    "A/A"
"c"    "A/A"    "G/G"    "A/A"
"d"    "G/G"    "A/G"    "A/G"
"e"    "A/G"    "G/G"    "A/G"
"f"     "A/A"    "G/G"    "A/G"
"g"    "A/A"    "G/G"    "G/G"
"h"    "A/A"    "G/G"    "G/G"
"I"     "A/A"    "G/G"    "G/G"

input1c

Code:

"aphab"    "S1"    "S2"    "S3"
"a"    "A/A"    "A/A"    "A/A"
"b"    "A/G"    "A/G"    "A/A"
"c"    "A/A"    "G/G"    "A/A"
"d"    "G/G"    "A/G"    "A/G"
"e"    "A/G"    "G/G"    "A/G"
"f"     "A/A"    "G/G"    "A/G"
"g"    "A/A"    "G/G"    "G/G"
"h"    "A/A"    "G/G"    "G/G"
"I"     "A/A"    "G/G"    "G/G"

input2

Code:

"ID"    "Label"    "log"
"S1"    "xxx"    2.8
"S1"    "xxx"    3
"S1"    "xxx"    4
"S2"    "yyy"    6.8
"S2"    "yyy"    7
"S2"    "yyy"    7.4
"S2"    "yyy"    8
"S3"    "zzz"    12
"S3"    "zzz"    14
"S3"    "zzz"    16
"S3"    "zzz"    18
"S3"    "zzz"    20

ouput

Code:

"ID"        "Label"     "StYPE"     "Ntype"     "Stype_No"  "log"
"S1"        "xxx"       "A/A"       1           18           2.8
"S1"        "xxx"       "A/G"       2           6           3
"S1"        "xxx"       "G/G"       3           3           4
"S2"        "yyy"       "A/A"       1           3           6.8
"S2"        "yyy"       "A/G"       2           6           7
"S2"        "yyy"       "G/G"       3           18          7.4
"S2"        "yyy"       "NULL"      "null"      "null"      8
"S3"        "zzz"       "A/A"       1           9           12
"S3"        "zzz"       "A/G"       2           9           14
"S3"        "zzz"       "G/G"       3           9           16
"S3"        "zzz"       "NULL"      "null"      "null"      18
"S3"        "zzz"       "NULL"      "null"      "null"      20

Last edited by stateperl; 03-06-2010 at 04:50 AM..

stateperl

View Public Profile for stateperl

Find all posts by stateperl

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

joining 2 files

Hi, I have two files that I need to find difference between. Do I use diff or join? If join, how do I use it? thanks, webtekie

2. Shell Programming and Scripting

Help with joining two files

Greetings, all. I've got a project that requires I join two data files together, then do some processing and output. Everything must be done in a shell script, using standard unix tools. The files look like the following: File_1 Layout: Acct#,Subacct#,Descrip Sample: ...

3. Shell Programming and Scripting

joining two or more files

i have three files file a has contents 123 234 238 file b has contents 189 567 567 and file c has contents qwe ert ery

4. Shell Programming and Scripting

Joining Three Files

Hi guys, I have three files which needs to be joined to a single file. File 1: Col a, Col b, Col c File 2: Col 1a, Col 1b File 3: Col 2a, Col 2b Output: Col 1a, Col 2a, Col a, Col b, Col c. All the files are comma delimited. I need to join Col b with Col 1b and need to...

5. UNIX for Dummies Questions & Answers

Joining two files

I have two comma separated files. I want to join those filesa nd put the result in separate file. smaple data are: file1: A1,1,100 A2,1,200 B1,2,100 B2,2,200 file2 1,50 1,25 1,25 1,100 1,100 2,50 2,50

6. Shell Programming and Scripting

Joining two files into one

Hi experts, I'm quite newbie here!! I have two seperate files. Contents of file like below File 1: 6213019212001 8063737 File:2 15703784 I want to join these two files into one where content will be File 3: 6213019212001 8063737 15703784 Regards, Ray Seilden

7. Shell Programming and Scripting

Help with joining files and adding headers to files

Hi, I have about 20 tab delimited text files that have non sequential numbering such as: UCD2.summary.txt UCD45.summary.txt UCD56.summery.txt The first column of each file has the same number of lines and content. The next 2 column have data points: i.e UCD2.summary.txt: a 8.9 ...

8. Shell Programming and Scripting

Joining 2 Files

File "A" (column names: Nickname Number GB) Nickname Number GB PROD_DB0034 100A 16 ASMIL1B_DATA_003 100B 16 PSPROD_0000 1014 36 PSPROD_0001 100D 223 ..... File "B" (column names: TYPE DEVICE NUMBER SIZE) TYPE DEVICE NUMBER SIZE 1750500 hdisk2 100A 16384 1750500 hdisk3 ...

9. Shell Programming and Scripting

Please help me in joining two files

I have two files with the below contents : sampleoutput3.txt 20150202;hostname1 20150223;hostname2 20150716;hostname3 sampleoutput1.txt hostname;packages_out_of_date;errata_out_of_date; hostname1;11;0; hostnamea;12;0; hostnameb;11;0; hostnamec;95;38; hostnamed;440;358;...

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

joining 2 files

Discussion started by: webtekie

2. Shell Programming and Scripting

Help with joining two files

Discussion started by: rjlohman

3. Shell Programming and Scripting

joining two or more files

Discussion started by: tomjones

4. Shell Programming and Scripting

Joining Three Files

Discussion started by: mac4rfree

5. UNIX for Dummies Questions & Answers

Joining two files

Discussion started by: pandeesh

6. Shell Programming and Scripting

Joining two files into one

Discussion started by: RayanS

7. Shell Programming and Scripting

Help with joining files and adding headers to files

Discussion started by: rrdavis

8. Shell Programming and Scripting

Joining 2 Files

Discussion started by: Daniel Gate

9. Shell Programming and Scripting

Please help me in joining two files

Discussion started by: rahul2662