Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Combine columns from 100 files with same structure
Top Forums UNIX for Dummies Questions & Answers Combine columns from 100 files with same structure Post 302695315 by mirni on Sunday 2nd of September 2012 06:47:02 PM
Old 09-02-2012
Try this:
Code:
#!/bin/bash

awk '{print $1}' PUR.*  | sort -u > keys  #save all keys
while read k ; do 
  out="$k"
  for f in PUR.* ; do
     a=$(grep "^$k " $f | awk '{printf("%-4.3f %-4.3f %-4.3f", $2,$3,$4)}') 
     [[ -z "$a" ]] && a="   -     -     - " 
     out="$out $a " 
  done  
  echo "$out" 
done  < keys

It assumes you can glob all inputs with PUR.*
Last edited by mirni; 09-03-2012 at 03:23 AM.. Reason: fixed to print the key
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

MV files from one directory structure(multiple level) to other directory structure

Hi, I am trying to write a script that will move all the files from source directory structure(multiple levels might exist) to destination directory structure. If a sub folder is source doesnot exist in destination then I have to skip and goto next level. I also need to delete the files in... (4 Replies)
Discussion started by: srmadab
4 Replies

2. Shell Programming and Scripting

Combine multiple columns from multiple files

Hi there, I was wondering if someone can help me with this. I am trying the combine multiple columns from multiple files into one file. Example file 1: c0t0d0 c0t2d0 # hostname vgname c0t0d1 c0t2d1 # hostname vgname c0t0d2 c0t2d2 # hostname vgname c0t1d0 c0t3d0 # hostname vgname1... (5 Replies)
Discussion started by: martva
5 Replies

3. UNIX for Dummies Questions & Answers

combine the values from the first two columns within a file

Hello everybody, I have a text file containing 10,000 rows and 5000 columns. The values are separated by a tab. Ex. file_ex.ped 1 mike 0 0 2 1 A A G G C T A G 1 jack 0 0 2 2 T A G T C A A C 1 Mary 0 0 1 2 A T G C A T G C ... I would like a out put file 1 mike 0 0 2 1 AA GG CT AG 1... (7 Replies)
Discussion started by: Unilearn
7 Replies

4. Shell Programming and Scripting

How to combine 2 files into 1 file with 2 columns

Hi Guys, I want to combine 2 files and and put together in 1 file and make two columns out it. See below desired output. Any help will be much appreciated. inputfile1.txt 12345 67890 24580 inputfile2.txt AAAAA BBBBB CCCCC (11 Replies)
Discussion started by: pinpe
11 Replies

5. UNIX for Dummies Questions & Answers

How to combine 2 files with 6 columns?

This may seem obvious but I am having problems doing this as columns get converted to rows when i try to write a script. I have 2 files text1.txt and text2.txt each of which have 6 columns of numbers separated by a space. I need to combine the 2 files so that the output file text3.txt maintains... (2 Replies)
Discussion started by: tgoldstone
2 Replies

6. Shell Programming and Scripting

Combine columns from multiple files

Can anybody help on the script to combine/concatenate columns from multiple files input1 4 135 5 185 6 85 11 30 16 72 17 30 21 52 22 76 input2 2 50 4 50 6 33 8 62 10 25 12 46 14 42 15 46output (2 Replies)
Discussion started by: sdf
2 Replies

7. Shell Programming and Scripting

Combine columns from many files but keep them aligned in columns-shorter left column issue

Hello everyone, I searched the forum looking for answers to this but I could not pinpoint exactly what I need as I keep having trouble. I have many files each having two columns and hundreds of rows. first column is a string (can have many words) and the second column is a number.The files are... (5 Replies)
Discussion started by: isildur1234
5 Replies

8. Shell Programming and Scripting

Combine columns - awk

Need some help with this ... please 60644,NJ090237_0263_GRP,NJ090237_0263_VIEW,NJ090237_0263_PSGRP,NJ090237_0263_GOLD_CSGRP,,06E:0_08E:0_09E:0_11E:0,0CE5,TDEV,34,VP_TIER... (3 Replies)
Discussion started by: greycells
3 Replies

9. Shell Programming and Scripting

Combine Columns

Input NJ090237_0263_GRP,NJ090237_0263_VIEW,NJ090237_0263_PSGRP,NJ090237_0263_GOLD_CSGRP,06E:0_08E:0_09E:0_11E:0,0CE5 NJ090237_0264_GRP,NJ090237_0263_VIEW,NJ090237_0264_PSGRP,NJ090237_0263_GOLD_CSGRP,06E:0_08E:0_09E:0_11E:0,0CE5... (7 Replies)
Discussion started by: greycells
7 Replies

10. UNIX for Beginners Questions & Answers

Automate splitting of files , scp files as each split completes and combine files on target server

i use the split command to split a one terabyte backup file into 10 chunks of 100 GB each. The files are split one after the other. While the files is being split, I will like to scp the files one after the other as soon as the previous one completes, from server A to Server B. Then on server B ,... (2 Replies)
Discussion started by: malaika
2 Replies

LEARN ABOUT CENTOS

scsi_start

SCSI_START(8)							     SG3_UTILS							     SCSI_START(8)

NAME

       scsi_start - start one or more SCSI disks

SYNOPSIS

       scsi_start [--help] [--verbose] [--wait] DEVICE [DEVICE]*

DESCRIPTION

       This bash shell script calls the sg_start utility on each given DEVICE. The purpose is to spin up (start) each given DEVICE.

OPTIONS

       Arguments to long options are mandatory for short options as well.

       -h, --help
	      print out the usage message then exit.

       -v, --verbose
	      increase level or verbosity.

       -w, --wait
	      wait for the spin up (start) on each given DEVICE to complete.  The default action is to do each start in immediate mode.

NOTES

       If a large number of disks are spun up at the same time (i.e. without the --wait option) then the power supply may be overloaded.

EXIT STATUS

       The  exit  status of this script is 0 when it is successful. Otherwise the exit status is that of the last sg_start utility called. See the
       sg3_utils(8) man page.

AUTHORS

       Written by D. Gilbert

COPYRIGHT

       Copyright (C) 2009-2013 Douglas Gilbert
       This software is distributed under a FreeBSD license. There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A  PARTICULAR  PUR-
       POSE.

SEE ALSO

       sg_start (sg3_utils)

sg3_utils-1.36							     May 2013							     SCSI_START(8)
All times are GMT -4. The time now is 05:13 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy