Search Results

Awesome, that's really useful. A rookie mistake no doubt but one that I won't make again any time soon, hopefully! Thanks

Thanks, that worked a treat. Had a little play around with that code, and realised one of the issues with my initial code was the use of new lines in inappropriate places. If I put a line between the...

Hi, I'm trying to use awk arrays to compare values across two files based on multiple columns. I've attempted to load file 2 into an array and compare with values in file 1, but success has been...

Hi, I was wondering if someone would be able to help with extrapolating information from a file and filling an existing matrix with that information.

I have made a matrix like this (file 1):
A...

Awesome, Pamu that worked perfectly, thank you.

balajesuri, that chucked up an error, but I am using a BSD version of join so that might be the reason why!

Cheers to you both

Hi, I am trying to merge information across 2 files. The first file is a "master" file, with all IDS. File 2 contains a subset of IDs of those in File 1.

I would like to match up individuals in...

Don that works perfectly. Does exactly what I wanted. Also, thanks for so clearly annotating your lines, I can tell exactly what you've done and that's really helpful for a relative newbie like me....

Sorry that was a typo from me


2 1234 9999
2 2500 10000
2 14000 192000


Every value in column 2 is lower than column 3. Many thanks :)

Hi Don,

Sorry if I wasn't clear.

Field (column 1) goes up to 24 in both File 1 and File 2.
File 1 is unsorted.

File 2 is sorted, from 1-24 in column 1. It is then sorted by lowest...

Hi, I have the following problem that is beyond what I can currently do with bash scripting.

In file 1, I have ~ 2500000 values. Note this file is not sorted.


3 19 LABEL_A
3 37 LABEL_B
2...

That's fantastic franzpizzo, does exactly what I wanted. Thanks very much for your help :)

Hi, I have the following problem:

I have a list of files:

1.txt
2.txt
3.txt
4.txt


Then I have a list of variable names inside variable.txt:

A
B
C
D


I'd like to rename 1.txt,...

Hi, thanks that's also a great idea. There are instances where I could simply add on 6000, but others where I can't, so both yours and bipinajith's solutions should cover what I need. Thanks!

:) Brilliant. Many thanks!

Hi, I was wondering if someone could help with what is probably a fairly easy problem. I have two variables, i is between 1-5, j is between 11-15

I'd like to produce this:


1_11
2_12
3_13...

Sorry for the slow reply back. Brilliant that has solved it. Many thanks for your help CLX :)

Hi, thanks for your rapid response. I changed the code a little because it kept throwing up syntax errors.

fruit=(apples bananas)
for i in {0..1}
do
awk 'FNR==1 {i++} {print $0 FS i}'...

Hi, I was wondering if anyone could assist me for (what is probably) a very straightforward answer.

I have input files containing something like


File 1

Apples
Apples
Apples
Apples
...

Hi, many thanks for your reply! That prints the max value in column 2 for the specific name in column 3, but not the minimum value in column 1. I'll have a play and see if I can get that to work. One...

Hi,

I have a file with the following columns:


361459 447394 CHL1
290282 290282 CHL1
361459 447394 CHL1
361459 447394 CHL1
178352861 178363529 AGA
178352861 178363529 AGA...