I have a tab delimited file with 3 columns that include semicolon separated data. I want to filter values in each column as such (meet all 3 criteria across the 3 columns): first column (<-0.5), second column (>1), third column (>2). The real data has multiple columns.
Input
-0.6;0.14;-0.56;0.2 10.4;NA;5.1;2 3;1;4;3 A;B;C;D
-0.9;-0.16;-1.1 2.4;0.1;0.9 10;1;3 E;F;G
Desired output
-0.6;-0.56 10.4;5.1 3;4 A;C
-0.9 2.4 10 E
For each row, the number of values in each column should be the same before and after filtering.