Hello,

I need few clarification in types of paste command ussage in coulmn mode :

In a directory i have few file distinguished as *.cpu *.vmem and *.mem

and have coulmn entries like
first cpu file
89576
89576
89576
89576
89576
89576
89576

second cpu file
46312
46312
46312
46312
46312
46312
46312
46312
46312
and third cpu file
46392
46392
46392
46392
46392
46392


and i want my output as
first file,second file, third file
89576,46312,46392
89576,46312,46392
89576,46312,46392
89576,46312,46392
89576,46312,46392
89576,46312,46392


i can do it easily by paste command paste -d"," first cpu file second cpu file third cpu file > output

but i dont know how many number of files there are for cpu extn....

i wrote a script :

ls -ltr |tr -s " " ";" |cut -d";" -f9 |egrep "(.cpu$|.vmem$|.mem$)" > temp1
cut -d"." -f1,2 temp1 |sort -u |> temp2

for var in `cat temp2`
do
paste -d"," $var" >> out
done

But it will paste the file i same coulmn:

Pls suggest possible one line command for it .I think using nawk or sed i can do it but i amd not having good Knowledge of them ...

thanks in advance
Aparna

I was able to do what i wanted by the following script
ls -ltr *.vmem |tr -s " " ";" |cut -d";" -f9 |sort -n > list_vmem
var1=`tr -s '\n' ' ' < list_vmem`
var2=`tr -s '\n' ',' < list_vmem`
echo $var2 > output_vmem.csv
paste -d"," $var1 >> output_vmem.csv
ls -ltr *.mem |tr -s " " ";" |cut -d";" -f9 |sort -n > list_mem
var1=`tr -s '\n' ' ' < list_mem`
var2=`tr -s '\n' ',' < list_mem`
echo $var2 > output_mem.csv
paste -d"," $var1 >> output_mem.csv
ls -ltr *.cpu |tr -s " " ";" |cut -d";" -f9 |sort -n > list_cpu
var1=`tr -s '\n' ' ' < list_cpu`
var2=`tr -s '\n' ',' < list_cpu`
echo $var2 > output_cpu.csv
paste -d"," $var1 >> output_cpu.csv



But can soembody PLs suggest one line solution for multiple files to be paste coulmn wise when we dont know the number of files to be pasted......

Thanks

Hi Aparna

You have multiple types of files and unknown count of each . I don't have a single liner as you asked for. But a slighter smaller version than you have in hand. Please try this to see if its of any use

#/bin/ksh
for i in "cpu" "vmem" "mem"
do
paste -d"," *.${i} > ${i}.out
done

As you guess, it makes three files cpu.out, vmem.out and mem.out!!!

Thanks a lot it works.............