Search Results

Works perfectly thank you very much! I'll race it against the python script!

@sk1418
Yeah that's exactly what I was after! Sorry I didn't articulate it well when I first posted. I tried to just copy and paste your example, but am coming up with an error message.

Is there...

Hi,
Given the following input files:

file1.txt


41109297
41109706
43162207
41109808
41109377
41110441
41111192
43163011
43162367

file2.txt


I Name 41109297 41109297...

Thanks vgersh99,

I think I realised that and pointed it out in the last line of my post. I hadn't anticipated the problem when I originally posted, but require output to match the order of file1

Hi,
Given the following input files:

file1.txt


41109297
41109706
43162207
41109808
41109377
41110441
41111192
43163011
43162367
file2.txt


I Name 41109297 41109297...

Interesting. that it's worked for you both, but not for me. I've tried to run your examples as shell scripts or using the awk -F option and I get really weird results if any results at all? However,...

Thanks for the replies

@sk1418
I tried your example, but never received anything back from stdout after running the scripts. I've tried to run the first awk command inputing file2.txt and...

Thanks for the quick reply unfortunately your example doesn't work.

I tried to run flot.awk and got the following

A single entry for the column header ~100 columns and then the entire matrix...

Hi,

I'm having trouble pulling out columns where the headers match a file of key ID's I'm interested in and was looking for some help.

file1.txt
I
Name
34
56
84
350
790
1215
1919
7606...

@danmero

Well I took your advice and went back to the statement that you referenced and everything seems to be behaving now! I don't know what I was getting to throw me off. However, I did notice...

Here is a slice of one of the data files.

I Name 146125883 146125883 146125889 146125889 146125926 146125926
M 10080_COIII B B B B B B
M GGaluGA000006 A A A B A A
M GGaluGA000013 A A A B A B...

Thanks for your reply. I've tried your example but I am still having problems. The files I would like to modify are more than 200 cols wide and vary extensively and when I try and use different file...

Hi,

I'm having a problem printing two consecutive columns, as I iterate through a large matrix by twenty columns and I was looking for a solution.

My input file looks something like this
1...

Thanks for both your replies. Sorry about the lack of detail, but rdcwayx was spot on with what I was attempting. Also thanks for the reference to the useless backticks. I'm trying to teach myself...

Hi I'm trying to loop through a small list of id's and then pull out a few columns if the id matches that found in column 2 of the larger file. I managed to get one command to work

awk -F " "...

Works perfectly. Thanks, I hadn't thought of sed...

Hi,
I'm looking for a clever way to print all columns of a matrix twice using a for loop and NF I think. So instead of

awk -F "," '{print $1 " " $1 " " $2 " " $2...}

I can do something like ...

Thanks for the suggestions. I ended up using something similar to the first suggestion, but written in python. I was hoping to do it in a bash script, but had some trouble with the other two...

Hi I'm having a problem with converting a file:

ID X
1 7
1 8
1 3
2 5
2 7
2 2

To something like this:

ID X1 X2 X3
1 7 8 3
2 5 7 2
...