Entering edit mode
4.9 years ago
xxxxxxxx
▴
20
I have 2 files-
File 1-
MU1234
MU1522
MU1856
MU3615
File 2-
MU1234 MU3615 MU1777 MU1522 MU1234 MU1856
1 0 1 1 1 1
0 0 1 1 0 1
0 1 1 1 0 1
1 1 1 1 1 1
0 1 0 1 0 0
1 0 0 0 1 0
I want to extract those column of file 2 if file 1 elements are present in file 2.
Expected output-
MU1234 MU1522 MU1856 MU3615
1 1 1 0
0 1 1 0
0 1 1 1
1 1 1 1
0 1 0 1
1 0 0 0