from 2 files create 1 2

[adimstec]

Hello ,

Another deal :

I have 2 files FIC1 and FIC2 and I need to create a third one named FIC

FIC1
VG1:data1:data2:data3:data4
VG2:data5:data6:data7:data8

FIC2
VG1:disk1
VG1:disk2
VG2:disk3
VG2:disk4
VG2:disk5
VG2:disk6


FIC
VG1:data1:data2:data3:data4:disk1:disk2
VG2:data5:data6:data7:data8:disk3:disk4:disk5:disk6


Thank you in advance.

 

[Chacalinc]

why don't you try to read an awk's manual? you have made the same question before:

http://www.tek-tips.com/viewthread.cfm?qid=1181680&page=1

Cheers.

Chacal, Inc.

 

[PHV]

Something like this ?
awk 'BEGIN{FS=OFS=":"}{v=$1;$1="";a[v]=a[v] $0}END{for(i in a)print i a}' FIC1 FIC2 > FIC

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Annihilannic]

awk -F: '
        { for (i=2;i<=NF;i++) { a[$1]=a[$1]":"$i } }
        END { for (i in a) { print i a[i] } }
' FIC1 FIC2

Annihilannic.

 

[adimstec]

PHV, Annihilannic : TOTAL RESPECT , it works great !

Chacalinc : you are probably rigth , I should read a awk's manual but because I needed a quick solution, I knew I can find it in this place with people like PHV or Annihilannic.

Again, Thank you anf you can be very proud of yourself !