Search Results

Thanks Raj.

After a lot of testing (I know close to nothing about Linux/Unix/awk) I managed to make some modifications to the script:
awk 'BEGIN{i=1}{
x=$1;
y=$5":"$6
...

I have seen the powerful perl program and would like to learn more.

Also, I would like to add a few more columns to the output file.

From the perl program given earlier:
perl -lane '$c{"$F[4]...

Ok, I see. That is why it is not working for:

File1 bb xx xx aab rrt xx
File1 xx xx xx ccd bbt xx
File1 xx xx xx ggt iir xx
File2 xx xx xx ggt iir xx
File2 xx xx xx ccd bbt xx
File3 aa xx xx...

Ok, but how is this awk command selecting which columns to include. From the script I cannot see how columns 4 and 5 are used to compare their values. I am sorry for all the questions, but trying to...

This is also very interesting as it might be easier for me to modify. However, when running this it seems to output all columns, counting correctly the and adding the "lane#" to each new line. The...

Thanks, that did what I wanted. What I did myself yesterday before reading your reply was to run:
awk -F "lane" '{print NF-1}' perl_output_file > new_count_filefollowed by:
paste new_count_file...

Wow! Thanks for the swift reply. I am almost there. However, upon running the perl script I got the following "comma" in the wrong place:

perl -lane '$x{"$F[4] $F[5]"} .= "$F[0],"; END{for(keys...

Hi. I am not sure the title gives an optimal description of what I want to do. Also, I tried to post this in the "UNIX for Dummies Questions & Answers", but it seems no-one was able to help out.

I...

Hi. I am not sure the title gives an optimal description of what I want to do.

I have several text files that contain data in many columns. All the files are organized the same way, but the data...