as said, i have awk experience but i have problems in programming logic for my problem.
one very rude solution would probably be (and i will try to program it now):
loop twice over all combinations, concatenating for all names all lines if one of the names is already present in the concatenated names list.
finally sort and make unique all concatenated names...
---------- Post updated at 10:55 AM ---------- Previous update was at 07:42 AM ----------
my first solution - don't blame me if you get eye- or brain-cancer from this code - you wanted to show my solution :rolleyes:
in test.txt is the example from my first post (tab-delimited).
h h,h,h,h,h,h,h,
a a,a,a,a,a,a,a,
b b,b,c,c,c,d,d,d,d,c,c,g,g,g,c,b,g,c,b,b,b,c,b,c,b,b,c,c,b,b,c,c,d,d,g,c,b,b,c,c,b,c,c,c,d,c,d,d,c,d,d,d,c,d,c,g,d,c,g,g,c,g,c,
c c,c,d,c,d,c,d,c,d,g,c,g,g,g,c,b,g,c,b,b,b,c,c,c,b,b,c,c,c,c,c,c,c,d,d,c,d,d,d,c,g,g,c,c,b,b,c,c,b,c,c,c,d,c,d,d,c,d,d,d,c,d,c,g,d,c,g,g,c,g,c,b,b,c,
d d,d,c,b,c,c,c,c,c,d,d,d,d,d,c,g,d,c,g,g,g,c,d,b,c,g,d,c,b,d,d,b,c,c,d,d,c,g,c,b,g,c,b,b,c,b,c,c,b,c,c,c,d,c,d,d,c,d,d,d,c,d,c,g,g,c,
e e,f,f,e,e,f,f,f,e,e,f,f,e,e,e,e,f,e,f,e,e,f,f,e,e,
f e,f,f,e,e,f,f,f,e,e,f,f,e,f,f,f,f,e,f,e,e,f,f,e,e,
g b,c,c,c,d,d,d,c,g,d,c,g,g,g,c,b,g,c,b,b,b,c,g,c,g,b,c,c,g,g,c,c,d,d,g,c,b,b,c,c,b,c,c,c,d,c,d,d,c,d,d,d,c,d,c,g,d,c,g,g,c,g,c,
the clean-up and sorting will be easy...
---------- Post updated at 12:02 PM ---------- Previous update was at 10:55 AM ----------
i don't have to load the file three times, i could use always one array.
i have to concatenate all combinations and loop over this array (as often as necessary) and look if there is one of the two combinations present in the concatenation and than add the other of the two names.
Let me tell you frankly this forum has got prompt support, We won't tolerate this kind of behavior here, forum is from people and for people, there is no spoon feeding. if you are not getting reply it does not mean that forum is useless, member might be busy at their work, or trying to solve the issue but not replied or they might not understand your requirement there can be plenty of reasons for why you did not receive reply. if you are posting thread which does not reach people then perhaps your post might be useless.
Don't talk nonsense, there are many members who feels so proud about this forum and I am one of them.
I have to second Akshay Hegde in that those kind of remarks are not really appreciated. Unfortunately I didn't see it when I started to work on the solution ...