Search Results

Hello all,

I want to consolidate my data group by cities into 4 rolled up code categories (first 2 characters of 2nd col), namely PR, GR, TY and others.

CHICAGO PR1
CHICAGO GR3
CHICAGO GR4...

Hi Chubler_XL,

The code is working perfectly with the sample data,but if i add a couple of more levels, it seems to miss some rows in the output

Sample 2

SSGG765 L1 1 2 3
SSGG765 L2 4...

Hi Chubler_XL,

Did you mean this line?

SSGG765 GUHJHJJ7 L5 10 12 13 SSGG765



This is because this line exists
GUHJHJJ7 L5 10 12 13


but for L5, SSGG765 does not have any...

There are 3 values (cols 3,4,5) for each name (col 1) and level (col2 ). Some levels for some of the names do not exist. Files are space delimited

SSGG765 L1 1 2 3
SSGG765 L2 4 5 6
GUHJHJJ7 ...

I`m sorry if I made this post ambiguous, reading through your replies I think Don understands the problem correctly.

Here is my attempt, which gives me a wrong output

awk ...

hello all,

i have ids repeated with alias names starting with different patterns like 'ab' , 'fg' etc...sometimes the same pattern names are repeated with the same ids like id=1 has names ab1 as...

Thank you ! this is running now..I will get back to you if I find some issues.. thank you again....

Number of parents is 234 now, but it will grow,, the data file has much redundant data where parents and children have many redundant/extra variables which will not appear in output.. the max size of...

Can I do this with code? Since the data file has 800 million records, it is impossible to do this manually, sorry for so many questions.

Thank you disedorgue, does your code require any sorting of the first or second files?
I`m running this on a huge dataset and getting weird output for some pair of parents.

wow..unbelievable, thank you from my heart..never thought it will require so much time and effort..

I will do testing and then confirm results...meanwhile if you can also post a short description...

thank you for letting me join this forum, lots of learning opportunities looks like.
Myself a biologist, very new into unix, so please excuse if I use incorrect language. I am using cygwin on...