Search Results

The special characters come from a pedigree code in plant breeding which has all sorts of characters like [, ], *,- ,@ , /, \,(,) space embedded in alphanumeric strings. Do you need a super-set of...

Hello gurus,

I have a lookup table

cat tmp1
[//rtwttwtr*fgg]\\\erw``~ 1
^774574574565665f[[[//]\] 2
()42543^[[D^[[D^[[D^[[D^[[D353535345****@3242- 3



and I`m trying to compare a bunch...

You are right, I was just copying and pasting from the actual data and not the demo one.

Here it is

join -1 2 -2 1 -o 1.1 1.2 1.3 2.2 2.3 file1 sortedfile | awk '$3 < $5 && !a[$1$2]++{print ...

Hello experts,

I have a file looking like

v1 g1 5.42
v2 g1 2.43
v1 g2 1.24
v3 g2 0.6

I want to lookup the first value in another sorted table which is greater than column 3 value, keying...

Hello,

I am trying to extract valid data blocks from invalid ones. In the input the data blocks are separated by one or more blank rows. The criteria are

1) second column value must be 30 or...

Hello gurus,

I am having trouble selecting consensus name, if any, for each group in my data.

The rules are

1. A group is defined by the first 2 columns.
2. The last column defines the...

yes, is there any alternative? I have to join on the first 2 fields, and not on the first field..also I believe the solution provided is also based on just joining on the first field ?

thanks ! can the 3rd column be picked up on the fly and not hard-coded ? The reason is I have multiple pairs of files to join..and I want to do them in a loop rather than hardcoding the names...

Hello all,

I want to join 2 tabbed files on the first 2 fields, and filling the missing values with 0. The 3rd column in each file is constant for the entire file.


file1...

Let me explain once more with a simpler example.

I have a datafile where the columns are in no particular order and missing values indicated as "NULL".

Sample Loc Rep T1 T2 C1 C2 C3...

Please help me in the following,

I have a matrix file

S2 S1 S3 S4 S5
G1 11 12 13 14 15
G2 21 22 23 24 25
G3 31 32 33 34 35
G4 41 42 43 44 45

a datafile

Sample Loc Rep T1 T2 T3...

please help, I want to group together all linked data pairs.

If I have 10 pairs, each row showing col2 and col3 are linked.

R1 1 2
R2 1 3
R3 2 4
R4 3 4
R5 5 6
R6 8 1
R7 6 7
R8 9 10
...

Hello everybody:

I want rearrange about 5 million rows (with 300 columns) into groups.

Data looks like the following: where there were various experiments (column 2) conducted at different...