Hi I have two tabular datasets.
Chr1 27710692 Chr2 23208700 Chr3 23909605 Chr4 25771913 Chr5 24355883
Chr3 Chr1 Chr2
I am searching for a tool where the rows from the dataset1 are returned when the first column matches the first column of dataset 2. The files are not sorted and order might differ.
The expected output would be
Chr1 27710692 Chr2 23208700 Chr3 23909605
I tried searching in text tools but could not find one. I would be grateful for a tool suggestion.