UNIX for Dummies Questions & Answers

Hello every one, plz help me out. I m using 4 files in unix, like file1, file2, file3,file4 in which primary key is ID in column(field) of 4 files.
On the bases of ID, i want the corresponding field of 4 files in final file let say collected file. In collected file, ID column should occur only one time i.e should not be repeated.

I m doing my efforts.
I appreciate the effort in advance.

Can you show us what you've tried so far?

Regards

Firstly i genrate a file in which i have unique ID of each file let say Unique_ID.txt
After that on the basis of unique ID, i find the corresponding fields from 4 file and then paste it w.rt to ID.
In which, each time ID get repeated in Collected file.txt(final file)

cut -d"," -f2 file1.txt >> tmp.txt
cut -d"," -f2 file2.txt>> tmp.txt

sort -u tmp.txt > Unique_ID.txt

Can you clarify your question with some examples of the contents of your files and the desired output?

Regards

suppose i have 3 file like file1, file2, file3 in which

file1 contains 10 number of fields(column wise) like
ID, Name, Address, remark etc.
001,AA,43,rrrr
002,FF,44,gg

file2 contains let say 4 fields like
ID,marks,%age etc.
001,43,66
003,43,77

file3 contains 3 number of fields like
ID, amount,balance etc.
001,55,555
003,44,444

Now result i want should be like in single like collected_file.txt file it should contain
ID,Name,Address,remark,marks,%age,amount and balance on the bases of ID
001,AA, 43, rrr, 43, 66, 55, 555
002,FF, 44, gg
003, 43, 77, 44, 444


Hopes it will help U.

You can use the join command, check the man page and search for some examples of join.

Regards

join command will work only on fixed field of file(s).
if i have numbers of file in which field are not fix.
then what to do???

please describe in details.

Thanks