Hi,

I have data which have three column. In first column I have name, while second and third column have one or more than one semicolon (;) separated values. Now I want to print row which have distance <= 10 and MAF is >= 0.5. In column second and third column each (;) separated ordered. If same position value have Distance <= 10 and MAF <= 0.5 then print the line. I would be happy if some one provide me R code, if not in R then AWK/SED is OK.

Thanks

Example

ID Distance MAF

cg12044689 8;40 0.000200;0.59

cg12143629 0;1;3 0.000200;0.520;0.0413

cg12247699 42 0.599

cg12375698 1;10 0.00231;0.51

Output should be:

ID Distance MAF

cg12143629 0;1;3 0.000200;0.520;0.0413

cg12375698 1;10 0.00231;0.51